Performance penalty of Measures in Filters Pane in Power BI
In this blog let's take a look at the performance of a report when you use a Measure in the Filter Pane. Let's say you have a data model...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
Mar 10, 20227 min read
Getting started with Aggregations in Power BI - Part 1
In this article let's take a look at how to get started with aggregations feature in Power BI. I will try to explain aggregations in a...
5960
Antriksh Sharma
May 29, 20215 min read
Optimizing calculations involving CROSSJOIN in DAX for Power BI, Power Pivot and SSAS.
In this blog I am going to show you how you can optimize a simple measure involving CROSSJOIN and in the process we are also going to...
2,5770
Antriksh Sharma
May 2, 20214 min read
Why you shouldn't add a 0 at the end of a DAX code
Power BI allows you to create reports easily by bringing columns from multiple tables or from a single table and by putting those columns...
6240
Antriksh Sharma
May 1, 20213 min read
Compute PARALLELPERIOD without using PARALLELPERIOD in DAX
PARALLELPERIOD is a DAX function that allows you to shift MONTH, QUARTER, or YEAR based on the the dates visible in the filter context,...
8250
Antriksh Sharma
Feb 23, 20212 min read
Thinking Behind Use of KEEPFILTERS in DAX
In this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...
6260
Antriksh Sharma
Jan 20, 20215 min read
Power BI DAX: Context Transition - Behind the scenes
Context transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...
4620
Antriksh Sharma
Nov 22, 20208 min read
Running Totals exclude days from the calculation
Creating a Running Total is pretty simple in DAX, you just take a measure, wrap it inside CALCULATE and then with the help of DATESYTD...
1,1170
bottom of page