How do I calculate the ratio of the ingredient to the number of total recipes per cuisine?

[HamidBee]

Hi,

I'll like to ask  how do I calculate the ratio of the ingredients to the number of total recipes per cuisine?

I'm attaching the pbix file below:

https://www.mediafire.com/file/x041zl3nuce94fz/W2.pbix/file

Any help would be appreciated.

[v-easonf-msft · Accepted solution]

Hi, @HamidBee 

Does ‘428275’ refer to the total recipes?

Please try measures as below:

Count =
VAR a =
    SELECTEDVALUE ( Recipes[Cuisine] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Recipes' ),
        FILTER ( 'Recipes', Recipes[Cuisine] = a )
    )

New Ratio = DIVIDE([Count],428275)

If I misunderstood, please share your expected result for further research.

Best Regards,
Community Support Team _ Eason