Understanding the DAX CALCULATE function

0 votes

I am working on a model in Power BI that has two datasets:

Set_1 (just a list of each group name)

and Set_2, a bunch of values per group in a different dataset:

But I don't understand why the CALCULATE function, which doesn't take any filter contexts as parameters works the way it does in this instance

Sep 28 in Power BI by anonymous
• 3,400 points
43 views

1 answer to this question.

0 votes

Using the CALCULATE function makes the DAX perform a context transition.

The value in the Group column of each row acts as a filter when you use CALCULATE as if you had written something like CALCULATE(SUM(Set_2[Value]), Set_2[Group] = 1). Even though it doesn't have an explicit filter, the row context acts as a filter.

answered Sep 28 by Gitika
• 42,520 points

Related Questions In Power BI

0 votes
1 answer

Calculate and filter function - DAX

Hi Praneeth, Calculate () by default perform calculations ...READ MORE

answered May 2, 2019 in Power BI by Cherukuri
• 32,490 points
263 views
0 votes
1 answer

To Calculate the Standard Deviation in Power BI

Suppose you've to obtain the Standard Deviation ...READ MORE

answered Nov 26, 2018 in Power BI by Upasana
• 8,620 points
7,692 views
0 votes
1 answer

Calculate Total number of Male & Female in the PowerBI report

To achieve what you are looking for, ...READ MORE

answered Feb 28, 2019 in Power BI by Upasana
• 8,620 points
2,229 views
0 votes
1 answer

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

answered Mar 18, 2019 in Power BI by Cherukuri
• 32,490 points
9,344 views
0 votes
1 answer
0 votes
1 answer

DAX Userelationship function

 You need a way for the measure ...READ MORE

answered Oct 5 in Power BI by Gitika
• 42,520 points
25 views
0 votes
1 answer

DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

answered Oct 1 in Power BI by Gitika
• 42,520 points
78 views
0 votes
1 answer

How do I label bar graph with different colors based on values from different slicers?

If the user selects only one value ...READ MORE

answered May 20, 2019 in Power BI by avantika
• 1,500 points
202 views
0 votes
1 answer

DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

answered Sep 24 in Power BI by Gitika
• 42,520 points
62 views
0 votes
1 answer

How do I use the DAX function ParallelPeriod?

The DAX expression you used in the ...READ MORE

answered Oct 5 in Power BI by Gitika
• 42,520 points
27 views