I have the following real table:
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:
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.