cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
freiburgc Regular Visitor
Regular Visitor

Share of top 10 Products (Revenues) to total revenues

Hello everybody,

 

I need your help again.

 

I would like to calculate the share of my top10 (revenues) products of total revenues.

 

 

First of all I calculate the top 10 revenues:

 

Pos2 = IF(HASONEVALUE('Artikelübersicht (ITEM)'[Artikelnr. & Beschreibung]);RANKX(ALL('Artikelübersicht (ITEM)'[Artikelnr. & Beschreibung]);[Absoluter Umsatz]))

'Artikelübersicht (ITEM)'[Artikelnr. & Beschreibung]) = Item Table with column Articleno. and Description

Absoluter Umsatz= Calculated measure that shows total revenues

 

Cumulated revenues based on top 10:

 

Kumulativer Umsatz Artikel = SUMX(TOPN([Pos2];CALCULATETABLE(VALUES('Artikelübersicht (ITEM)'[Artikelnr. & Beschreibung]);ALL('Artikelübersicht (ITEM)'[Artikelnr. & Beschreibung]));[Absoluter Umsatz]);[Absoluter Umsatz])

With following code I try to estimate the share of top 10 products to total revenues:

 

Verteilung Artikel = [Kumulativer Umsatz Artikel]/CALCULATE([Absoluter Umsatz];All('Artikelübersicht (ITEM)'[Artikelnr. & Beschreibung]))

But it doesn´t work. My result:

 

Unbenannt.png

The result should be, 12.785.625/36.979.651=0,35.

 

36.979.651 are total revenues. 

 

Does anybody can give some hint to solve my problem?

 

I´m thankfull for every help I can get!! 🙂

 

Thanks and have nice weekend

Christian

 

3 REPLIES 3
Community Support
Community Support

Re: Share of top 10 Products (Revenues) to total revenues

Hi @freiburgc

The last column is incorrect in each row or the total row?

Where is measure[Absoluter Umsatz] from your screen picture?

 

Best Regards

Maggie

freiburgc Regular Visitor
Regular Visitor

Re: Share of top 10 Products (Revenues) to total revenues

Hello @v-juanli-msft,

 

thanks for your answer.

 

I´m sorry, but I don´t understand your questions.

 

That is how the solution should look like:

 

Pos.RevenuesShare of
total sales
13.574.155 €9,67%
22.078.080 €5,62%
31.297.273 €3,51%
4947.658 €2,56%
6937.228 €2,53%
7934.346 €2,53%
8881.280 €2,38%
9713.826 €1,93%
10666.218 €1,80%
 12.030.064 €32,53%
   
   
 Total Revenues36.979.651 €

 

 

Absoluter Umsatzer = Total Revenues.

 

Sorry for that...

 

Christian

Community Support
Community Support

Re: Share of top 10 Products (Revenues) to total revenues

Hi @freiburgc

Could you tell me how to calculate the result?

This means which columns are used for calculation and how to write the formula?

Sorry for my stupid question, i don't understand the language on your screenshot and can't relate those information with your last post.

 

Best Regards

Maggie

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors