cancel
Showing results for
Did you mean:

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

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
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.

``````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.

2 REPLIES 2
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.

``````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.

Super User

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())

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

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors