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 need to get the distinct count of products in a matrix by customer. I want it to count the # of products sold that have sales for each customer. The measure counts the products as 1 on the product level of the matrix, but it always shows 59 at the customer and segment levels (59 is the total count of all products). In the below example it should show 2.
My Matrix is set up :
Count | |
Segment | 59 |
Customer | 59 |
Product | 1 |
Product | 1 |
Solved! Go to Solution.
Does this work more like you expect?
CALCULATE (
DISTINCTCOUNT ( 'Product Class'[Major Planning Group Name] ),
Sales
)
Does this work more like you expect?
CALCULATE (
DISTINCTCOUNT ( 'Product Class'[Major Planning Group Name] ),
Sales
)
Hi @astano05 ,
What does Sales refer to in your initial formular? Is this a measure or a column?
Maybe try it with this:
Count = CALCULATE ( COUNTROWS ( 'Product Class' ), Table[Sales] <> BLANK() )
/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 @astano05 ,
I'll give it a shot. Would it work with this?
Count = CALCULATE ( COUNTROWS ( 'Product Class' ), NOT ( ISBLANK ( Table[Sales] ) )
Let me know, if that helped 🙂 Otherwise feel free to share some data!
/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 |
thanks for the reply! i get this error with this formula with calcluate.
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |