Calculated Column for Assigning Quintiles

[Anonymous]

Hi, 

I want to be able to assign quintiles to Geos based on their indicator value. I've created measures to calculate the percentiles and a measure to assign the quintile (QuintileColour); these work perfectly fine.
As I can't use measures as a legend for the Shape Map visual i'm using ,I would like to create a calculated column to assign the quintiles. 

I tried using the same formula as the QuintileColour measure for the calculated column but it doesnt work, all values are assigned to the 1st quintile. 

Would be grateful if someone can help me do this

[v-xinruzhu-msft · Accepted solution]

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.