Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
astano05
Helper III
Helper III

Count Rows counting all values

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.

 

Count = if(not(isblank(Sales)),countrows(values('Product Class'[Major Planning Group Name])))

 

My Matrix is set up :

 Count
Segment59
     Customer59
          Product1
          Product1
1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

Does this work more like you expect?

CALCULATE (
    DISTINCTCOUNT ( 'Product Class'[Major Planning Group Name] ),
    Sales
)

View solution in original post

4 REPLIES 4
AlexisOlson
Super User
Super User

Does this work more like you expect?

CALCULATE (
    DISTINCTCOUNT ( 'Product Class'[Major Planning Group Name] ),
    Sales
)
tackytechtom
Super User
Super User

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! linkedIn

#proudtobeasuperuser 

tackytechtom
Super User
Super User

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! linkedIn

#proudtobeasuperuser 

thanks for the reply! i get this error with this formula with calcluate.

 

astano05_0-1647549003738.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.