October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
I would like to hide measure for colum2 and show total at colum1 level in Matrix. How it possible?
Solved! Go to 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.
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.
@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
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |