Forum Discussion
Final total should be subtracted
Dear
I have table with below value
DESC Budget VALUE Month
XXXX Budget - 2019 2000 1
XXXX Actual-2019 1000 1
YYYY Budget-2019 5000 1
YYYY Actual-2019 3000
When I use the Matrix visualization , It show me as
DESC Actual-2019 Budget-2019 Pending amount
XXXX 1000 2000 3000 (THis value should difference of "Budget-2019 - Actual-2019" means this must show as 1000)
YYYY 3000 5000 8000 (this should show the diff of Budget-2019-Actual-2019 means 5000-3000=2000)
Can any one tell how show the difference value
HERE the total should be diff of Budget-2019 and Actual-2019.
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.
1 Reply
v-yuta-msftCommunity Support
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.