Forum Discussion
Syndicate_Admin
Administrator
AdministratorTable shows non-existent row in data
Hello I am writing this message because I am not very clear about the reason why this happens to me. I explain my problem: I have the table I show above in a PBI dashboard. In it all the dat...
bcdobbs
Community Champion
Community ChampionProbably easiest to see with an example:
Person Dimension:
PersonId
A
B
C
Fact Table
PersonId, Amount
A, 10
B, 20
C, 30
D, 40
E, 50
with this setup your visual would return the values for A,B and C but then a blank row giving a value of 90.
As amitchandak explained you have rows in your fact table that the dimension doesn't know about.