Forum Discussion

YunJ's avatar
YunJ
Post Prodigy
6 years ago

Why all(column name) does not work?

Hi,

I made a category table, and link it to the other tables.

As you can see. there is also "Category" in my 2020 table. But I don't want it to be related to the Category table.

So I wrote measure as following. I was thinking this would ignore the Category sclier(used in Category table). But as you can see the results are the same as GMV which is original in my 2020 table.

Need Help

3 Replies

  • YunJ's avatar
    YunJ
    Post Prodigy
    6 years ago

    Hi, I found both GMV and the new measure I wrote are not related to Category table!

    As you can see, GMV value just sum up all the Category, not filter only Category=Skincare.

    So it seems like I didn't connect successfully "Category" column between 2020 table and Category table right? Why it doesn't connect?

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      You can check the Relationships view (bottom icon on the left pane) and create the relationship manually. Power BI relationship auto-detection is not flawless.