Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculated Column for Assigning Quintiles

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

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.