cancel
Showing results 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

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 Segment 59 Customer 59 Product 1 Product 1
1 ACCEPTED SOLUTION
Super User

Does this work more like you expect?

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

Does this work more like you expect?

``````CALCULATE (
DISTINCTCOUNT ( 'Product Class'[Major Planning Group Name] ),
Sales
)``````
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()
)```

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

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!

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

Helper III

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