Why all(column name) does not work?

[YunJ]

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.

[YunJ]

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]

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.

[amitchandak]

@YunJ ,Can you share sample data and sample output.