Forum Discussion

jrsdata's avatar
jrsdata
Regular Visitor
6 years ago
Solved

Creating Dynamic Ranking Tier Measure

Hi All-   Relatively new to Power BI.  I am looking to add a dynamic measure which would create a dynamic tiered ranking.  There should be 5 tiers.  For starters, each could comprise of 20%.  Howev...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey jrsdata ,

     

    i forgot the 1st CALCULATE ...

    this measure

    Measure = 
DIVIDE(
    CALCULATE(SUM('Table'[Policy Count]))
    , CALCULATE(SUM('Table'[Policy Count]) , ALL('Table'[County]))
)

    allows to create this little report:

    Regards,

    Tom

     

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey jrsdata ,

 

you can create a measure that calculates the contribution of a county like so:

 

share of county = 
divide(
sum('<tablename>'[Policy Count])
, calculate(sum('<tablename>'[Policy Count]) , all('<tablename>'[Policy Count]))
)

 

Then you can this measure to retrieve the rank from a table, that you have to add to your data model and that contains the ranks´.

 

These articles provide guidance how to tackle this kind of segmentation tasks:

Hopefully, this is what you are looking for.

 

Regards,

Tom

 

jrsdata's avatar
jrsdata
Regular Visitor
6 years ago

Hi Tom-

 

Tried implementing part 1 of your solution but seeing 1.00 across the board for 'share of county' measure.

  • TomMartens's avatar
    TomMartens
    Super User
    6 years ago

    Hey jrsdata ,

     

    i forgot the 1st CALCULATE ...

    this measure

    Measure = 
DIVIDE(
    CALCULATE(SUM('Table'[Policy Count]))
    , CALCULATE(SUM('Table'[Policy Count]) , ALL('Table'[County]))
)

    allows to create this little report:

    Regards,

    Tom