Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Final total should be subtracted

Dear   I have table with below value   DESC               Budget                   VALUE                Month XXXX               Budget - 2019         2000                  1 XXXX              ...
General Comment
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    You can create a measure using DAX below and drag the measure to the value field of the matrix.

    Difference = 
VAR Current_DESC = MAX('Table'[DESC])
VAR Budget_Value = CALCULATE(MAX('Table'[VALUE]), FILTER('Table', 'Table'[DESC] = Current_DESC && 'Table'[Budget] = "Budget-2019"))
VAR Actual_Value = CALCULATE(MAX('Table'[VALUE]), FILTER('Table', 'Table'[DESC] = Current_DESC && 'Table'[Budget] = "Actual-2019"))
RETURN
ABS(Budget_Value - Actual_Value)

     

     

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

You can create a measure using DAX below and drag the measure to the value field of the matrix.

Difference = 
VAR Current_DESC = MAX('Table'[DESC])
VAR Budget_Value = CALCULATE(MAX('Table'[VALUE]), FILTER('Table', 'Table'[DESC] = Current_DESC && 'Table'[Budget] = "Budget-2019"))
VAR Actual_Value = CALCULATE(MAX('Table'[VALUE]), FILTER('Table', 'Table'[DESC] = Current_DESC && 'Table'[Budget] = "Actual-2019"))
RETURN
ABS(Budget_Value - Actual_Value)

 

 

Community Support Team _ Jimmy Tao

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