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
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , As a measure, is calculated at each row and grand total level. Your calculation will change based on that

 

You need to use some kind group

Version2 =
sumx(values(FORECAST[columns]), X + CALCULATE(sum(FORECAST[Forecast]),filter(FORECAST,FORECAST[position]<=X)))

 

change columns to with group by you want in visual