Table shows non-existent row in data

[Syndicate_Admin]

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 data except "Product Score" and "CRM Score" are from the same data set. The scores have been added by relating their respective tables to the large table, creating a star model.

But for some reason that empty row appears at the beginning that has very high scores (like a sum). In power query I have done a filtering step of the Product Score and CRM Score tables. Could it have had something to do with it? How do I remove that row?

Thanks a lot

[v-angzheng-msft]

Hi, @Syndicate_Admin 

May I ask if your problem has been solved? Is the above post helpful to you?

If  it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bcdobbs]

Probably 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.

[amitchandak]

@Syndicate_Admin , This means one of the nonsummarized columns from a dimension has value in fact which is not available in dimension.

This means you fact has additional dimension key, which is not avaiable in diemsion

[Syndicate_Admin]

I'm sorry, but I'm afraid I don't understand what you mean.

[amitchandak]

@Syndicate_Admin , It means you many side table in schema has some values which is not present on the one side of table

Also, refer

https://www.youtube.com/watch?v=23qemkDqMVY