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.
Hi there
Is there a way that a matrix table can have a subtotal option ON but we can customise the columns it subtotals?
I have the below table that has values that I would like to subtotal but I don't want the text columns to have data at subtotal level (doesn't make sense anyway).
Any assistance would be appreciated. Thank you.
Solved! Go to Solution.
Hi @donodackal ,
I created some data:
Here are the steps you can follow:
You can create measures for your Text columns.
1. Create measure.
Text_measure =
IF(
NOT (ISINSCOPE('Table'[Group]))||ISINSCOPE('Table'[Index])
,MAX('Table'[text]),BLANK())
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @donodackal ,
I created some data:
Here are the steps you can follow:
You can create measures for your Text columns.
1. Create measure.
Text_measure =
IF(
NOT (ISINSCOPE('Table'[Group]))||ISINSCOPE('Table'[Index])
,MAX('Table'[text]),BLANK())
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |