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.
Hello all,
I made a matrix, in which x is divided by Total Costs and Proceeds in a matrix. Both of them have a subtotal.
What I want is to only show for the Total Costs the subtotal, not for the Proceeds. This can't be done by the settings of the matrix, because this will turn on or off both values and you can't select different values for one column separately.
So, does anyone know how to keep the subtotal for the Total Costs, and disappear the subtotal for the proceeds?
Thank you in advance.
Regards,
Tom
@Tom02 it can't be done via matrix formatting options, but you can make it via DAX.
Example: i have matrix which shows year and category in rows, profit and quantity in values.
I want to show quantity only on category and total level, but not on year subtotals.
Here is calculation:
Cheers,
Nemanja Andic
Hi @nandic,
Thank you for your answer. Unfortunately I can't use this formule for two reasons:
First I want to get rid of one subtotal column and not of a row.
So, only giving me one subtotal column, instead of two.
Second is that the column which contains the Proceeds and Total Costs is not numeric, it is just text. Therefore I can't use a SUM function.
I hope I informed you better with this information.
Regards,
Tom
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |