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
My problem is similar to this one, but excluding values when not found.
I have a "Store" column and a "Product" column and i want to show all products from the store only when it has the product "Paint", if a store doesn't have "Paint" in one of its rows i need a filter that excludes all of the store in all pages of my model.
If this is my Data:
ID | Store | Product |
1 | 1 | Chips |
2 | 1 | Paint |
3 | 2 | Paint |
4 | 3 | Soda |
5 | 3 | Chips |
I want my model to work only with this rows (Store 1 and 2):
ID | Store | Product |
1 | 1 | Chips |
2 | 1 | Paint |
3 | 2 | Paint |
Thanks a lot!
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new table.
Expected result calculated table =
VAR _storewithpaint =
SUMMARIZE ( FILTER ( Data, Data[Product] = "Paint" ), Data[Store] )
RETURN
CALCULATETABLE ( Data, TREATAS ( _storewithpaint, Data[Store] ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new table.
Expected result calculated table =
VAR _storewithpaint =
SUMMARIZE ( FILTER ( Data, Data[Product] = "Paint" ), Data[Store] )
RETURN
CALCULATETABLE ( Data, TREATAS ( _storewithpaint, Data[Store] ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you!
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 |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
69 | |
47 | |
46 | |
20 | |
15 |