Hide values in table, but show in table total

[Anonymous]

Hi,

In the following table I only want to show the companies with ranking category TOP and hide ranking category REST, however I still want to show the total of TOP and REST in the total row at the bottom.

Any suggestions on how to achieve this?

Thanks!

[amitchandak]

@Anonymous , refer if these can help

https://community.powerbi.com/t5/Desktop/Top-5-and-others/td-p/165945

https://community.powerbi.com/t5/Desktop/Top-10-Other/td-p/51282

[Greg_Deckler · Accepted solution]

@Anonymous - You could do something like this:

Measure 4 = IF(HASONEVALUE('Table (4)'[Column1]),IF(MAX('Table (4)'[Column2])="Rest",BLANK(),SUM('Table (4)'[Column3])),SUMX(ALL('Table (4)'),[Column3]))

See attached PBIX below sig. Page 4, table 4

[Anonymous]

Thanks for your help.

[Greg_Deckler]

Absolutely!