Share of top 10 Products (Revenues) to total revenues

[Anonymous]

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:

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

[v-juanli-msft]

Hi @Anonymous

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

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

Best Regards

Maggie

[Anonymous]

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.	Revenues	Share of total 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

[v-juanli-msft]

Hi @Anonymous

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