Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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?
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.
@YunJ ,Can you share sample data and sample output.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |