Value only in subtotal row

[Raul]

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:

1. I only want the DEP column value in the Area row
2. I only want the subtotal of Description row when the hour is 0 for Item value
3. I don't want to show the Description when its value is blank but I want its total in the Hour column.

How can I do it?

Thank you very much for your help.

[v-yulgu-msft]

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 

[Raul]

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?

[v-yulgu-msft]

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