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 all,
We are trying to build a report to identify customers who bought a specific product only, and not other products.
Tyring to adapt the solution from a similar thread to our context but we kept hitting into error. Appreciate if anyone can help.
https://community.powerbi.com/t5/Desktop/Customers-who-have-NOT-bought-a-product/td-p/199670
Measure = IF ( HASONEVALUE ( Items[Item] ), CALCULATE ( SUM ( Sales[Sales] ), FILTER ( Sales,NOT( CONTAINS ( Sales, Sales[Item], VALUES ( Items[Item] ) ) ) ) ), SUM ( Sales[Sales] ) )
Hi,
Share your data and also show the expected result there.
Hi,
My objective is to create a dynamic measure which returns the sales for customers who bought, say BABYBOY only.
Expected result from this snapshot: Return only CustomerNo = 23542 with Sales = 101.03
Thank you very much in advance!
Hi,
Thank you for clarifying. Please share a sample dataset to work with.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |