Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone!
I have this table in a pbix file:
COMPANY | ITEM | HOURS | INVOICED | DESCRIPTION | AREA | DEPARTAMENT |
B25 | A | 0,00 | 3453,00 | FCA | Area1 | Dep1 |
B25 | A | 0,00 | 192,80 | FCG1 | Area1 | Dep1 |
B25 | A | 0,00 | 125,00 | FCG2 | Area1 | Dep1 |
B25 | A | 0,00 | 11,40 | FCG4 | Area1 | Dep1 |
B25 | A | 0,00 | 184,79 | FF | Area1 | Dep1 |
B25 | C | 2,25 | Area1 | Dep1 | ||
B25 | D | 0,25 | Area1 | Dep1 | ||
B25 | E | 80,07 | Area1 | Dep1 | ||
B25 | I | 0,83 | Area1 | Dep1 | ||
B25 | K | 0,25 | Area1 | Dep1 | ||
B25 | M | 0,53 | Area1 | Dep1 | ||
B25 | P | 4,16 | Area1 | Dep1 | ||
B25 | S | 1,25 | Area1 | Dep1 |
And I show it in this matrix visualization:
But I want to show in this way:
COMPANY | HOURS | INVOICED | DEP |
B25 | 89,59 | 3.966,99 | |
Area1 | 89,59 | 3.966,99 | Dep1 |
C | 2,25 | 0,00 | |
D | 0,25 | 0,00 | |
E | 80,07 | 0,00 | |
I | 0,83 | 0,00 | |
K | 0,25 | 0,00 | |
M | 0,53 | 0,00 | |
P | 4,16 | 0,00 | |
S | 1,25 | 0,00 | |
FCA | 0,00 | 3.453,00 | |
FCG1 | 0,00 | 92,80 | |
FCG2 | 0,00 | 125,00 | |
FCG4 | 0,00 | 11,40 | |
FF | 0,00 | 184,79 | |
Total | 89,59 | 3.966,99 |
That is:
How can I do it?
Thank you very much for your help.
Hi @Raul,
I'm afraid that above requirements is not able to achieve. The matrix view you have got is a default format, currently, there is no option to dynamically show/hide subtotal or column values for specific row group.
Regards,
Yuliana Gu
Ok @v-yulgu-msft, thanks for your comment.
But, the other question about how show only in the Area row the Dep1 value for the DEP column is not possible with a DAX formula?
Hi @Raul,
In my test, I didn't find a solution to show DEP only in the Area row via DAX. I'm afraid this is not possible.
Regards,
Yuliana Gu
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |