Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |