The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
As a part of larger measure, I want to be able to tell the number of days in which a store has sold at least 1 of each from the user-selected products.
The default PowerBI interaction is that selecting multiple products will return the sales of any of those combined, so if an user selectes 3 products, it will display sales even if there's a day where only 1 or 2 of those were sold.
I am looking to only include dates and sales where all 3 were sold, could someone help me find a solution to this?
Was looking at the CONTAINS function, but the value parameter only accepts a singular scalar value and not a set.
@BachDinh , refer if this can help
And for Selected Values, All selected values are present: https://youtu.be/X5T4rIZovHk