Forum Discussion
DAX
I would like to hide measure for colum2 and show total at colum1 level in Matrix. How it possible?
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.
3 Replies
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
amitchandak - I wanted to completely hid the values at column2 and show totals at column 1 level regarless of expand /drill down
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.
