Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using a measure into Calculate+Filter VS using a constant equal to my measure

Hi,    I'm running some test to set my (pretty simple) measure but there is a thing that I dont understand.    When I use :  Version1 = 2 + CALCULATE(sum(FORECAST[Forecast]),filter(FORECAST,FO...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

If your metric is placed in a view with multiple fields, the results will be affected by rows, as in the following simple example.

x = CALCULATE(sum(FORECAST[Forecast]),filter(FORECAST,FORECAST[position]=2))

 

If you want the x measure to return the same result in all rows, add the ALL function.

x = CALCULATE(sum(FORECAST[Forecast]),filter(ALL(FORECAST),FORECAST[position]=2))

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.