Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Table 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:

data_operador1_0-1640940449892.png

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

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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.

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.