Issue with table visual with multiple selection in slicer

[amikm]

I am trying to get the top 5 Marks for the years 2021 and year 2022.

Here is the problem statement:

When I am selecting an Individual year, I am getting the top 5 marks from the table, but when I am selecting both year from the Slicer, I am not getting the expected output. I am using the TOP N filter from the Filter panel for Marks.

Note: I have 1000+ rows like this in the real dataset, this is just for the sample.

My expected output would be-

Thanks

[v-janeyg-msft · Accepted solution]

Hi, @amikm 

According to your description, I think you can create a measure and use it in filter pane to display the top 5.

Like this:

Top5 =
RANKX (
    SUMMARIZE ( ALLSELECTED ( 'Table Top' ), [Year], [Name] ),
    CALCULATE ( SUM ( 'Table Top'[Marks] ) ),
    ,
    desc,
    DENSE
)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[amitchandak]

@amikm , Assume you have measure marks, Create rank like this

rankx(filter(summarize(allselecetd(Table), Table[year], Table[name]), [year] = max([year])), [marks],,desc,dense)

if you need across year

rankx(summarize(allselecetd(Table), Table[year], Table[name])), [marks],,desc,dense)

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures