Calculated Column for Assigning Quintiles

Hi Anonymous 

Did you want to calculate  counts of the quintile? If you want to achieve this,you can refer to the following sample .

Sample data

I create the same measures as yours

Then create two table, one is quintile level table another is the country table

Then create a measure

Counts =
COUNTROWS (
    FILTER (
        'Sample data',
        [Country]
            IN VALUES ( 'Country'[Country] )
                && [QuintileColour] IN VALUES ( 'Level'[Level] )
    )
)

Put the measure and field of  country table and the field of  quintile level table to the visual.

Output

Best Regards!

Yolo Zhu

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