cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
47A Occasional Visitor
Occasional Visitor

Counting Number of Product Items

I need to get a total product count to calculate % of total. 

 

But, when I take out the Product Key, the Row Count changes as seen in attached picture. In the top table, the count of SKUs should remain as 2 but it increases to 3 once the product key is removed. Why is this happening? Thanks.

Capture.JPG

2 REPLIES 2
Super User
Super User

Re: Counting Number of Product Items

Hi,

 

RowCount should be a measure like this

 

=DISTINCTCOUNT(Data[SKU])

 

Does this work?

Community Support Team
Community Support Team

Re: Counting Number of Product Items

@47A ,

 

[Rowcount] might be a measure, right? Could you show the measure and table structure?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.