Matrix - not show data in total row

[Ltsh]

Hi everyone,

I have population data. it contains detail like Region, Sub region, Country, 2020 population,  2019 population and others. I want to use matrix control so I can show the values like following snap. When I pull country from Rows to "Value" section of matrix, it is showing me with the first country in total rows. But I want to not show the first country in total rows and show sum of 2020 population, 2019 population, and percantage only (I want to not show country as yellow text bar).

[Anonymous · Accepted solution]

Hi @Ltsh,

Please refer to the following blogs to know how to find out the specific hierarchy level of row contents, you can add filter to check the current level and replace the specific level of blank to ignore the total level value displayed.

Clever Hierarchy Handling in DAX 

Use IsInScope to get the right hierarchy level in DAX 

In addition, the simplest way is doing 'subtotal'/'grand total' settings on format panel, you can accurately control which field total displayed.

Create matrix visualizations in Power BI#subtotals-and-grand-totals-with-matrix-visuals 

Regards,

Xiaoxin Sheng

[Motasem_Yakhola]

Hello @Ltsh,

Why you are putting countries on values; instead of putting it on rows or columns to get the data of all countries in each region?

Looking for more clarification in order to help you.

Best wishes.

----------------------------------------------

Did I answer your question? Mark my post as a solution!

Don't forget to like my post please.

[Ltsh]

Hi @Motasem_Yakhola 

Because I want Sub region, country, population and percentage in same line.