Forum Discussion

emma313823's avatar
emma313823
Icon for Helper V rankHelper V
8 years ago
Solved

Blank line in table

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 connect...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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's avatar
erik_tarnvik
Icon for Solution Specialist rankSolution Specialist
8 years ago

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.