Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

In connecting 2 files - Why is the blank header(left) and respective count is appearing on the top

    Though we have total count at the bottom of the Matix, why there is the count at first row with blank header ?  I'm clueless.
Note: I choose "Count(Distinct)"
Kindly do the needful  count 2.PNG
Super User
Super User

Hi @MonikaNandhini1 

You'd need to show more of your model to get to an accurate answer. It could be that you simpliy have 652 rows for which the ComponentID is blank. Or, if you have a 1-to-many relationship through Component ID to another table, it could be that you have the table on the 1-side has component IDs that do not appear in the many-side table. Those will potentially be shown as blank, depending on how you build the visual.

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors