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.

BeemsC's avatar
BeemsC
Icon for Resolver III rankResolver III
8 years ago

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