DAX

[Naveen29]

I would like to hide measure for colum2 and show total at colum1 level in Matrix. How it possible?

[Anonymous · Accepted solution]

Hi @Naveen29 

@amitchandak Thank you very much for your prompt reply, please allow me to share some content here.

You can do this by creating a measure.

Measure 2 = 
SUMX(
    ALL('Table'),
    'Table'[Measure]
)

Create a matrix.

If you don't want blank lines, you can filter through the filters pane.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Naveen29 , You have the expand and collapse button in Matrix visual you can use those. Or you can use drill up and drill down

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Naveen29]

@amitchandak - I wanted to completely hid the values at column2 and show totals at column 1 level regarless of expand /drill down