Tables top N

[Anonymous]

Hi,

In a report I am creating a table that has sales figures, market share etc for mutiple models. However to keep it simple, I want to display the top 5 or for that matter say top n models. However when it comes to the summary, I would still like the table to display the summation considering all models and not just the top n. 

Help is appreciated.

Regards,

Rahul

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to create a measure with ALL Function and HASONEVALUE Functionas below. If you need further help, please provide some data sample and expected output for your scenario.

Top5 =
IF (
    HASONEVALUE ( Table2[Name] ),
    SUM ( Table2[Values] ),
    SUMX ( ALL ( Table2 ), Table2[Values] )
)

Regards,

Cherie