Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Tables top N

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

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

     

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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