cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
1 REPLY 1
Highlighted
Super User III
Super User III

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

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

Cheers 

SU18_powerbi_badge

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.