Forum Discussion
Matrix - not show data in total row
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
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.
