Blank line in table

[emma313823]

Hi All

I have a table showing the current month of commissions received by accounts or principal.  I have a table of principal names (unique names) and a relationship of this unique table connected to an excel file that contains years of this data. I have the table set through conditional formatting to display all principals from the unique table and when I select the month from the excel spreadsheet it shows what principal has paid and which ones have not.

In the image I have one line that shows the month, yet no principal name or value...both source files have absolutely no blank lines of data and I've already checked for phantom lines and they do not exist.  I don't know where this blank line is coming from.  I have the table set to DISPLAY ITEMS WITH NO DATA because I need to see who has paid and who has not.  

Does anyone have any idea why this blank line is showing?  This was a table I had to recreate and I've mirrored all settings exactly from the original yet this first line shows blank.

[v-chuncz-msft · Accepted solution]

@emma313823,

As mentioned here, if the incoming relationship is broken, DAX adds a new row to the related table that has blanks in every field, and links that new row to the unindexed row to guarantee referential integrity. You may add Visual level filters to get around it.

[erik_tarnvik]

Are you 100% sure that you do not have an entry in the excel file for which there is no matching value in your principals name table? It is not clear from your question, but if the PRINCIPAL column comes from the principals table, it would display a blank in this situation. One suggestion would be to replace PRINCIPAL in this table with a column from your excel table and see if you still get a blank line.

Sorry if this doesn't make sense, I may be making some perhaps unwarranted assumptions with regards to your data structure.

[BeemsC]

Try removing blank rows from your principal column in using the query editor.
Let me know if it works