Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
@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.
@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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |