Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I would like to remove some subtotals from a matrix table, like this:
I tried with this formula, but something is missing from it:
The problem is that I have to crate another channel named: "Direct Secom", which is a total of "LL Other", "Farmacii Independente" and "LL KA":
And the chain is from another table.
So I have Level 1 Channel/Canal drilled down level 2, which is Chain for all level 1 except "Direct Secom", which has "LL Other", "Farmacii Independente" and "LL KA".
Hi @Anonymous
Please try
IF (
ISBLANK ( SELECTEDVALUE ( CanalGrup[Canal 2] ) ) && HASEONEVALUE ( CanalGrup[Canal 2] ),
BLANK ( ),
"The rest of the calculation...
)
User | Count |
---|---|
51 | |
37 | |
20 | |
14 | |
13 |
User | Count |
---|---|
94 | |
72 | |
30 | |
21 | |
13 |