cancel
Showing results for
Did you mean:
Regular Visitor

Share of top 10 Products (Revenues) to total revenues

Hello everybody,

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:

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

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

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

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

Best Regards

Maggie

Regular Visitor

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

Hello @v-juanli-msft,

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

That is how the solution should look like:

 Pos. Revenues Share oftotal sales 1 3.574.155 € 9,67% 2 2.078.080 € 5,62% 3 1.297.273 € 3,51% 4 947.658 € 2,56% 6 937.228 € 2,53% 7 934.346 € 2,53% 8 881.280 € 2,38% 9 713.826 € 1,93% 10 666.218 € 1,80% 12.030.064 € 32,53% Total Revenues 36.979.651 €

Absoluter Umsatzer = Total Revenues.

Sorry for that...

Christian

Community Support

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

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

Announcements

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!

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?

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