Forum Discussion
Solved
Variance between two measure values
Hi All, I am attempting to calculate the difference between multiple forecast scenarios. As an example, from the screeshot below, i am attempting to calculate the difference column based on the prior...
jawilson808 , A new column
new column =
[Value] - Sumx(filter(Table,[forecast]="forecast 1"),[value])/// or a new measure
new measure =
sum(Table[Value]) - Maxx(filter(allselected(Table),[forecast]="forecast 1"),[value])
amitchandak A follow up question to the above. How can I critique this formula for when its drilled down on. As an example, when drilling down on Forecast 2 the difference is equal to it self. I believe this has something thing to do with the "maxx" used in the formula.