Ranking Filter

[Thulasiraman]

Hi 

I have created ranking for various items like sales value, sales quantity, product category etc and created 3 matrix tables displaying the ranking of the above values.

I have used the dax RANKX = RANKX(ALLSELECTED(column name, expression)

The above dax gives the ranking for entire values from 1 to till end.

I want to filter all the tables for top 5 and don't want to use the visual filters by going into each visual.

Is there a way to use the parameter so that if I slide to a specific number, the ranks in all the tables changes?

Appreciate your help very much and thanks in advance.

Thulasiraman

[Mahesh0016]

Hello @Thulasiraman ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Thulasiraman]

Hello @Mahesh0016 

Thanks for reply.

Can I send the photo of the matrix tables or you want the entire pbix file?

[Mahesh0016]

you can share table matrix of expected result.

[Thulasiraman]

[Thulasiraman]

I have used the visual filters of RANKX in the above matrix

[Mahesh0016]

Hello @Thulasiraman ,
can you share related Dax query you have.

[Thulasiraman]

Yes, following are the queries:

RANKX(ALLSELECTED('Itemwise DC All'[Dye Item]), [Total cost])

RANKX(ALLSELECTED(JobNoMaster[New Shade]), [Prod Qty])

RANKX(ALLSELECTED(JobNoMaster[New Shade]), [Prod value])