Value only in subtotal row

Question

Hello everyone!&nbsp;I have this table in a pbix file:&nbsp;COMPANYITEMHOURSINVOICEDDESCRIPTIONAREADEPARTAMENTB25A&nbsp; &nbsp; &nbsp;0,00&nbsp; &nbsp; 3453,00FCAArea1Dep1B25A&nbsp; &nbsp; &nbsp;0,00&nbsp; &nbsp; &nbsp; 192,80FCG1Area1Dep1B25A&nbsp; &nbsp; &nbsp;0,00&nbsp; &nbsp; &nbsp; 125,00FCG2Area1Dep1B25A&nbsp; &nbsp; &nbsp;0,00&nbsp; &nbsp; &nbsp; &nbsp; 11,40FCG4Area1Dep1B25A&nbsp; &nbsp; &nbsp;0,00&nbsp; &nbsp; &nbsp; 184,79FFArea1Dep1B25C&nbsp; &nbsp; &nbsp;2,25&nbsp;&nbsp;Area1Dep1B25D&nbsp; &nbsp; &nbsp;0,25&nbsp;&nbsp;Area1Dep1B25E&nbsp; &nbsp;80,07&nbsp;&nbsp;Area1Dep1B25I&nbsp; &nbsp; &nbsp;0,83&nbsp;&nbsp;Area1Dep1B25K&nbsp; &nbsp; &nbsp;0,25&nbsp;&nbsp;Area1Dep1B25M&nbsp; &nbsp; &nbsp;0,53&nbsp;&nbsp;Area1Dep1B25P&nbsp; &nbsp; &nbsp;4,16&nbsp;&nbsp;Area1Dep1B25S&nbsp; &nbsp; &nbsp;1,25&nbsp;&nbsp;Area1Dep1&nbsp;And I show it in this matrix visualization:&nbsp;But I want to show in this way:&nbsp;COMPANYHOURSINVOICEDDEPB25&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;89,59&nbsp; &nbsp; 3.966,99&nbsp;&nbsp; &nbsp;Area1&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;89,59&nbsp; &nbsp; 3.966,99Dep1&nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp; &nbsp; E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80,07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp; &nbsp; I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,83&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp; &nbsp; K&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp; &nbsp; M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,53&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp; &nbsp; P&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4,16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp; &nbsp; S&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp;&nbsp; &nbsp;FCA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp; &nbsp; 3.453,00&nbsp;&nbsp; &nbsp;FCG1&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;0,00&nbsp; &nbsp; &nbsp; &nbsp; 92,80&nbsp;&nbsp; &nbsp;FCG2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp; &nbsp; &nbsp; &nbsp;125,00&nbsp;&nbsp; &nbsp;FCG4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; 0,00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11,40&nbsp;&nbsp; &nbsp;FF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,00&nbsp; &nbsp; &nbsp; &nbsp;184,79&nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 89,59&nbsp; &nbsp; 3.966,99&nbsp;&nbsp;That is:I only want the DEP column value in the Area rowI only want the subtotal of Description&nbsp;row when the hour is 0 for Item valueI 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.&nbsp;

v-yulgu-msft · Answer

Hi&nbsp;Raul,
&nbsp;
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.
&nbsp;
Regards,
Yuliana Gu&nbsp;

raul · Answer

Ok&nbsp;v-yulgu-msft, thanks for your comment.&nbsp;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 · Answer

Hi&nbsp;Raul,
&nbsp;
In my test, I didn't find a solution to&nbsp;show DEP&nbsp;only in the&nbsp;Area&nbsp;row via DAX. I'm afraid this is not possible.
&nbsp;
Regards,
Yuliana Gu

Forum Discussion

Value only in subtotal row

3 Replies

Related content

Customize subtotal in matrix

Replacing Subtotal Values

subtotal not work in metrics (value has "if" statement)

Matrix subtotal

how to off row subtotal for only one value in matrix

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