Count of values

[abhishek_2593]

Hi,

I have a table which has products with multiple values/variable, i would like to count the sum of these values/variable for each product. Can someone please help with this measue?

[v-easonf-msft]

Hi, @abhishek_2593 

If you need a measure, please try  formula like:

Result1 =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Product] = MAX ( 'Table'[Product] ) )
)

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@abhishek_2593 , a new column

= Calculate(distinctcount(Table[Websites]), filter(Table, [Product] =earlier([Product]) ))