I need to calculated already in a Power BI Matrix a column that is Total Value minus column a & b
a & b columns are already defined and whatever is not a & b should go to other category
shows a + b = total
I need to generate other column so that it is li
a + b + other = total
Can you share some sample data in table format and show how the matrix visual looks like currently? For example, what is on rows/columns and what is in values? And what is the matrix expected to be like?
Best Regards,Community Support Team _ Jing
That was my idea but I keep getting dax formula error. Please, can you explain how?
check it out on Microsoft Learn! https://learn.microsoft.com/en-us/powerquery-m/value-subtract
hi @JorgePerez91 have you tried to create a calculated column in your dataset where you substract the sum of a+b from Total ?
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.