Distinct Count Measure and Ranking

[vincenttys]

Hi,

A relative beginner question hopefully some expert here will be able to provide some guidance.

I have created a measure for distinctcount from the data i got. Example: my measure now show Monday 4, Tuesday 10, Wednesday 15, Thursday 10, Friday 1, Saturday 20, Sunday 15.

I am trying to achive below, is this possible?

Day           Value      Rank

Saturday       20          1

Sunday         15           2

Wednesday  15           2

Tuesday        10          3

Thursday       10          3

Monday         4            4

Friday             1            5

Thanks

Vince

[v-eachen-msft · Accepted solution]

Hi @vincenttys ,

You can create a measure to rank your data.

RANK =
RANKX ( ALL ( Sheet1[A] ), [Value],, DESC, DENSE )

Sheet1 is your table name, A is your day column and Value is your measure.

Here is the final visual.

Best Regards,

Eads

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