Forum Discussion
Power BI remove row breakdown for some group values
Hi,
I have blelow data, the value of Total = Inventory + Trade + Others.
What I want to see in the matrix is to have only one line for Total, I don't want the breakdown of the Accounts for Total like below:
Is this possible?
Hi Anonymous
Create a calculated column like
cate = SWITCH(TRUE(),[Group] in {"Inventory", "Trade", "Others"},"total")Add matrix like:
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
v-juanli-msftCommunity Support
Hi Anonymous
Create a calculated column like
cate = SWITCH(TRUE(),[Group] in {"Inventory", "Trade", "Others"},"total")Add matrix like:
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- lbendlin
Super User
You can use a measure for the Account value. Blank it out when the Group is "Total", fill it with the Account value if not.
Then use summation for the Amount.
lbendlin , This might work, but I will loose the ability to drill down and up on the Account level.
- lbendlin
I don't think you mentioned that requirement. Have you tried using a matrix visual where you put Group and Account in the rows, Amount in the value, and nothing in the columns? Then expand all groups except the Total group.
