Want to show top 10 states sales

[supraja]

Hello All,

I have the sales data of 10+ states ( Sample Fields : states  ,Measures of sales, Rank by states & Ranking states by profit) and i want to show  Total of top 10 states  sales data. 

Please help us to show the data as mentioned.

Regards,

Supra.

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Top ten sales: =
CALCULATE (
    [Sales:],
    KEEPFILTERS ( TOPN ( 10, ALL ( Data[State] ), [Sales:], DESC ) )
)

[supraja]

Thanks Its Working 😀

[Gianluca88]

Hi @supraja 

try this 

So the important is to filter on the visual of your interest like in the image. Please check and let me know.

g.