cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
LomXof Frequent Visitor
Frequent Visitor

behavior of calculate inside another calculate

Hello everyone, given these two measures:

Measure1 = CALCULATE(CALCULATE(SUM([column]); Filter 1; Filter 2 ); Filter 3; Filter 4 ) 
Measure2 = CALCULATE(SUM([column]); Filter 1; Filter 2; Filter 3; Filter 4 )

Why do I obtain different results?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: behavior of calculate inside another calculate

HI @LomXof,

 

Please take a look at following blogs about filter priority in measure calculation.

 

Reference links:

Order of Evaluation in CALCULATE Parameters

Filter Arguments in CALCULATE

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: behavior of calculate inside another calculate

HI @LomXof,

 

Please take a look at following blogs about filter priority in measure calculation.

 

Reference links:

Order of Evaluation in CALCULATE Parameters

Filter Arguments in CALCULATE

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |