Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have the following real table:
Store | Id_Product | Sold |
Shopping | F10 | NO |
Street | F10 | YES |
Market | F10 | NO |
Shopping | F20 | NO |
Street | F20 | YES |
Market | F20 | YES |
Shopping | F30 | YES |
Street | F30 | YES |
Market | F30 | NO |
I have a slicer for Store on my page.
I need to make a measure that returns only products with Sold = YES on ALL Stores selected.
If user selects "Shopping" and "Street" for example, I need to show on a visual table the following result:
Id_Product | Measure |
F10 | 0 |
F20 | 0 |
F30 | 1 |
Like I said, the user selected "Shopping" and "Street" and the measure returns 1 only for Id_Product = F30, because it is the only product that have sold on "Shopping" and "Street".
Id_Product = F10 returns 0 because it doesn't sold on "Shopping"
Id_Product = F20 returns 0 because it doesn't sold on "Market" and "Shopping"
Id_Product = F20 returns 1 because it sold on "Market" and "Shopping".
I will use that measure to show on table just the values with 1, in other words, just products that have sold on all Stores selected.
Solved! Go to Solution.
Try this MEASURE
Measure = IF ( ISEMPTY ( EXCEPT ( VALUES ( Table1[Store] ), CALCULATETABLE ( VALUES ( Table1[Store] ), Table1[Sold] = "Yes" ) ) ), 1, 0 )
Try this MEASURE
Measure = IF ( ISEMPTY ( EXCEPT ( VALUES ( Table1[Store] ), CALCULATETABLE ( VALUES ( Table1[Store] ), Table1[Sold] = "Yes" ) ) ), 1, 0 )
Hey @Zubair_Muhammad
I tried your solution and it work correctly.
Thanks man, you are awesome!
Have a nice day!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |