Do not show the first row values when expanded using matrix

[vance]

Hi, 

How do i not show the first column values of the minimized table of the matrix?

E.g

[+] January |  Want blank  |    Want Blank |  Want Blank |

It was fine when its expanded, first row is blank.

[-] January |  Heres Blank |    Heres Blank |  Heres Blank |

                  |           1         |    6                  |  Yes             |

Thanks and Regards,

V

[amitchandak]

@vance , Not very clear. But isinscope should able to help you

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[vance]

Hi Amit,

I want it to be like this, hightlighted row is blank when not expanded.

It shows values when it not expanded.

Sorry for my bad explanation. I suspect its showing the 'First Value' alphabetically sorted.

[V-pazhen-msft]

@vance 

Turn off the row subtotals, it is on by default.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[vance]

Hi Paul,

I have already turned it off, anyway it doest not toggle the first row to appear nor disappear, only the totals below.

[vance]

Hi any kind souls able to help on this?