Forum Discussion

Nas's avatar
Nas
New Member
5 years ago

Filter by Field

Hi, May I please ask if its possible to filter Top 5 by field. The field contains Dom Air, Reg Air , Int Air. I would like to filter top 5 routes by Trns used by Dom Air, Reg Air, Int Air in one visu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

 Hi Nas ,

According to my understanding, you want to select top5 data based on three columns, right?

You could use the following formula:

rankColumn =
VAR a = [Dom Air]
VAR b = [Reg Air]
VAR t1 =
    FILTER ( ALL ( 'TopNTable' ), TopNTable[Dom Air] = a )
VAR t2 =
    FILTER (
        ALL ( 'TopNTable' ),
        TopNTable[Dom Air] = a
            && 'TopNTable'[Reg Air] = b
    )
RETURN
    RANKX (
        t1,
        RANKX ( t1, [Reg Air],, DESC, SKIP ) * 100
            + RANKX ( t2, [Int Air],, DESC, SKIP ) * 10,
        ,
        ASC,
        SKIP
    )

Then apply visual's filter : is less than or equal to 5 to visual :

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin

 

Nas's avatar
Nas
New Member
5 years ago

Hi @Eyelyn9

Thank you so much for your response.

Yes, top 5 data but based on one column. The column contains Dom Air, Reg Air, Int Air.

One Column

Dom Air Route Details 12

Route Details 11

Route Details 10

Route Details 9

Route Details 8

Int Air Route Details 12

Route Details 11

Route Details 10

Route Details 9

Route Details 8

Reg Air Route Details 12

Route Details 11

Route Details 10

Route Details 9

Route Details 8

Hope I am making sense

In