Solved: totals in a matrix

azaterol · ‎09-26-2022

Hello everyone,

I have a matrix that shows percentages and sales.

How can I hide the grand total here: 50.2%?
That doesn't make any logical sense to me either. If you add them together, you don't get 50.2%.

But I don't need a total percentage display. I would only like to have the total sales display for the sales.

Is it in Power BI possible to deactivate some totals in a matrix?

Jihwan_Kim · ‎09-26-2022

Hi,

One of ways to achieve this is wrting a measure something like below.

New Measure percentage total fix: =
IF (
    HASONEVALUE ( 'TableName'[The column that is used in this table matrix] ),
    [Pecentage measure]
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

View solution in original post

Jihwan_Kim · ‎09-26-2022

Hi,

One of ways to achieve this is wrting a measure something like below.

New Measure percentage total fix: =
IF (
    HASONEVALUE ( 'TableName'[The column that is used in this table matrix] ),
    [Pecentage measure]
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

totals in a matrix