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.
I want to count the number of distinct products where sum of sales are equal to zero.
Product and sales query are related by product.
The sales query may not have all products so the product must come from the product query not from the sales query.
Couple of methods below have been tried and not working:
SUMX(VALUES('Product'[Product Name]), IF(SUM(Sales[Amount]) = 0, 1))
CALCULATE(COUNT('Product'[Product Name]), FILTER(ALL('Sales'), SUM(Sales[Amount]) = 0 ))
Solved! Go to Solution.
Hi @009co ,
How about this one here:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Product'[Product Name] ), FILTER ( VALUES ( 'Product'[Product Name] ), CALCULATE ( SUM ( 'Sales'[Amount] ) ) = 0 ) )
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @009co ,
How about this one here:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Product'[Product Name] ), FILTER ( VALUES ( 'Product'[Product Name] ), CALCULATE ( SUM ( 'Sales'[Amount] ) ) = 0 ) )
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |