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, 2020 in Power BI by anonymous
• 8,870 points
1,610 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.

Also Read:

What are the best practices for optimizing DAX queries that use multiple CALCULATE statements?

How do you fix incorrect totals or results caused by filter context issues in DAX?

answered Sep 28, 2020 by Gitika
• 65,770 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
• 33,030 points
1,335 views
0 votes
1 answer

What are the best practices for optimizing DAX queries that use multiple CALCULATE statements?

To optimize DAX queries that involve using ...READ MORE

answered Oct 29 in Power BI by pooja
• 6,710 points
64 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
15,662 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
11,362 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,770 points
1,854 views
0 votes
1 answer

DAX Userelationship function

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

answered Oct 5, 2020 in Power BI by Gitika
• 65,770 points
1,209 views
0 votes
1 answer

Using RELATED function in DAX with USERELATIONSHIP

Here's an example using the AdventureWorksDW data ...READ MORE

answered Nov 18, 2020 in Power BI by anonymous
• 65,770 points
4,958 views
0 votes
1 answer

How to restart running total column with Power BI Desktop DAX?

This is not only a running total ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,770 points
1,895 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, 2020 in Power BI by Gitika
• 65,770 points
4,011 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, 2020 in Power BI by Gitika
• 65,770 points
960 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP