Forum Discussion

jawilson808's avatar
jawilson808
Helper I
5 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

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])