Forum Discussion

Fusilier's avatar
Fusilier
Icon for Helper III rankHelper III
2 years ago
Solved

Help with RANK function with and dynamic formatting

Hi, Two parts to this question: 1. I have data that is based on responses where the respondent is presented with a list of options and selects either Yes or No depending on whether the option is im...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi Fusilier 

    Create this as a new measure, make sure to put your own table and column names in

    Rank Questions =
    RankX( --Performs an expression for each row
            AllSelected('Combined Table'[Question]) --Remove internal filters keeps external
            ,    Calculate(Count(Combined Table'[Answer])) --Calculate applies a fitler

            ,DESC --Sort most to least

            ,Skip--If 2 questions rank 1st, third question gets 3nd not 2nd
    )

    Apply this measure in Cell elements  click the Fx symbol and change the Format Style to Field value
    Colour rank =
    If( [Rank Questions] <= 3, "Green", "Red")

     

     

SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
2 years ago

Hi Fusilier 

Create this as a new measure, make sure to put your own table and column names in

Rank Questions =
RankX( --Performs an expression for each row
        AllSelected('Combined Table'[Question]) --Remove internal filters keeps external
        ,Calculate(Count(Combined Table'[Answer])) --Calculate applies a fitler

        ,DESC --Sort most to least

        ,Skip--If 2 questions rank 1st, third question gets 3nd not 2nd
)

Apply this measure in Cell elements  click the Fx symbol and change the Format Style to Field value
Colour rank =
If( [Rank Questions] <= 3, "Green", "Red")

 

 

  • Fusilier's avatar
    Fusilier
    Icon for Helper III rankHelper III
    2 years ago

    Thank you. Works great!