Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a report with a matrix table with two columns that I want to show the difference between.
I cannot do this calculation in the Data table as it is the same column.
My data is in a table called "Data" and the fields are called "Type" and "Total".
'Data'[Type] contains several data series like "Actual", "Budget", etc. & 'Data'[Total] contains values.
I my matrix table in my report the column is 'Data'[Type] which is filtered into two columns "Actual" and "Budget" and Values is 'Data'[Total].
Now I want to make a third column called "Deviation" showing the difference between Actual and Budget.
Here is a screendump of my matrix:
Solved! Go to Solution.
Thanks for your fast reply!
Someone advised me to change my matrix table to a normal table by filtering my dataset so now it's much easier to do the excercise.
But thanks anyway!
Hi @flunte70,
Try something like this:
Deviation = CALCULATE ( SUM ( Data[Total] ), Data[Type] = "Actual" ) - CALCULATE ( SUM ( Data[Total] ), Data[Type] = "Budget" )
Should work.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks for your fast reply!
Someone advised me to change my matrix table to a normal table by filtering my dataset so now it's much easier to do the excercise.
But thanks anyway!
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |