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

[MonikaNandhini1]

    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  

[AlB]

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