Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Dshami
Frequent Visitor

Percentage of Total against top 5 sellers

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?

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1670299966331.png

 

Jihwan_Kim_1-1670300185320.png

 

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:] )

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1670299966331.png

 

Jihwan_Kim_1-1670300185320.png

 

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:] )

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


amitchandak
Super User
Super User

@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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.