Need help to calculate top values for measure

[Radhika2605]

HI Everyone!

I am working in a Restaurant data and I am trying to find top 2 cuisines per price range (low, medium, high). 

I have tried to use this measure but it doesn't seems to work-

Top 2 Cuisines with the Higest number of Restaurants =

CALCULATE( COUNT( 'Restaurant Cuisines'[Restaurant_ID] ),

TOPN( 2, ALL( 'Restaurant Cuisines'[Cuisine] ), COUNT( 'Restaurant Cuisines'[Restaurant_ID] ) ),

VALUES( 'Restaurant Cuisines'[Cuisine] ) )

When I put this in a table I get following. Left table is table which contains all the values as I have used the count property to count the number of restaurant within each category. Right side table also shows same values but instead of this I want it to have 2 values like this (just a sample)-

High   Bar                 5

High   Brewery         4

Low    American       1 

Low    Armenian      4

Can you please tell me what is wrong in my measure as I have used this measure before for finding top values and it worked perfectly fine. 

This is how my model looks - 

Thanks

Radhika

[v-kkf-msft · Accepted solution]

Hi @Radhika2605 ，

Try the following formula:

Measure = 
RANKX(
    ALL('Restaurant Cuisines'[Cuisine]),
    CALCULATE( COUNT('Restaurant Cuisines'[Restaurant_ID]) ),
    ,
    DESC,
    Dense
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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