Solved: Count of values with best rank

LoicCA · ‎12-02-2022

Hi Community,

I would like to create a table with the total count of the best status per product.

In my example, for product 1001 best status is C&V and Confirmed for product 1002, I would like to see the table of the right as a result.

How can I do that?

Thanks for your help

lbendlin · ‎12-04-2022

Measure = 
var r = min('Table'[Rank])
var a = SUMMARIZE(all('Table'),'Table'[Product],"rn",min('Table'[Rank]))
return countrows(FILTER(a,[rn]=r))

see attached

LoicCA · ‎12-03-2022

Hi.

This is my sample data:

Thanks!

lbendlin · ‎12-04-2022

Measure = 
var r = min('Table'[Rank])
var a = SUMMARIZE(all('Table'),'Table'[Product],"rn",min('Table'[Rank]))
return countrows(FILTER(a,[rn]=r))

see attached

lbendlin · ‎12-03-2022

Count of values with best rank