Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
bdehning
Post Prodigy
Post Prodigy

Remove Blanks in matrix table

I have this Matrix Table.   

bdehning_0-1722117665338.png

 

Here is my Values Measure

Top3CauseCount =
VAR CurrentRank = [RankCauseGrouping]
VAR CountValue = [Count of Total Gross Incurred +0]
RETURN
    IF(
        NOT(ISBLANK(CountValue)) && CountValue > 0 && CurrentRank <= 3,
        CountValue,
        BLANK()
    )

 

Here is RankCauseGrouping

 

RankCauseGrouping =
RANKX(
    ALLSELECTED('InjuryCause'[Cause Grouping]),
    [Count of Total Gross Incurred +0],
    ,
    DESC,
    DENSE
)

What do I need to to eliminate the blanks in my table?   

5 REPLIES 5
MattAllington
Community Champion
Community Champion

The first table you posted correctly displays the results. If you don't want to see the blanks, then set it up like the second table you posted.  If you want to use the first table structure with no blanks, please produce the table manually (using Excel) to show what you expect to see. I suspect doing this will help you realise that they way it is in the OP is the correct result. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.
MattAllington
Community Champion
Community Champion

You can simply turn off the totals for the visual



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Yes I can turn totals off but there is still the blank issue?

MattAllington
Community Champion
Community Champion

There are 4 rows in your table including the total row. Every row has at least 1 valid number to display. What result do you expect?



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

I may need to leave as a vertical table, since Top causes are not the same for each year.   I was hoping to show the Top 3 Causes by Count for each year.  Totals are strange as they muxt be picking up totals of causes outside the Top 3?

bdehning_0-1722119633868.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.