Percentage of Total against top 5 sellers

[Dshami]

I have a requirement to fetch top 5 sellers and to compare their total sales to the total amount of sales of that period. 

I need to use guage chart to show this.

How can I create a measure for total of top 5 seller's sales vs the total number of sales?

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

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

Revenue measure: = 
SUM( Sales[Revenue] )

Top 5 revenue measure: = 
CALCULATE (
    [Revenue measure:],
    KEEPFILTERS (
        TOPN ( 5, ALLSELECTED ( Seller[Seller] ), [Revenue measure:], DESC )
    )
)

Ratio: = 
DIVIDE( [Top 5 revenue measure:], [Revenue measure:] )

[amitchandak]

@Dshami ,

For top 5 you can use measure like

calculate([Net Sales], TOPN(5, allselected('Table'[Seller]), [Net Sales PY],desc), values('Table'[Seller]))

for grand total refer

calculate([Net Sales], allselected())

TOPN: https://youtu.be/QIVEFp-QiOk

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho