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 197 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, 2020 by
• 65,910 points
Hi, I am learning Power BI and trying to understand how calculate works without filter? = calculate(sum(sales.total_amout)). why cant we give sum(sales.total_amount)?

0 votes
1 answer

## Calculate and filter function - DAX

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

0 votes
1 answer

## To Calculate the Standard Deviation in Power BI

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

0 votes
1 answer

## Calculate Total number of Male & Female in the PowerBI report

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

0 votes
1 answer

## How to calculate cumulative Total and % in DAX?

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

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

0 votes
1 answer

## DAX Userelationship function

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

0 votes
1 answer

## Using RELATED function in DAX with USERELATIONSHIP

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

0 votes
1 answer

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

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

0 votes
1 answer

## DAX Calculate function with and without FILTER

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

0 votes
1 answer

## How do I use the DAX function ParallelPeriod?

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