Counting Number of Product Items

[47A]

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.

[v-yuta-msft]

@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.

[Ashish_Mathur]

Hi,

RowCount should be a measure like this

=DISTINCTCOUNT(Data[SKU])

Does this work?