Number of partners for turnover upto 50%, 80%, 100%

[vs_7]

i want to calculate number of partners for turnover upto 50%, 80%, 100%.

i am using sales table which is fetching from S4HANA.

output

[vs_7]

Hi @v-rongtiep-msft @amitchandak ,

My requirement is i need the no of count of partners from turnover upto 50% , 80%, 100% partners sales.

i need to calculate cummulative sales and count of partners.

I'm not getting the correct count of partners .

1.Turnover calculated dax 

TO upto 80% = CALCULATE([total_sales] * 0.8)

2.count measure 

Top 80% =

VAR custcount = DISTINCTCOUNT( 'ABR_2020-2021'[Reseller Code] )

RETURN

CALCULATE (

[TO upto 80%],

KEEPFILTERS (

TOPN ( custcount, VALUES ( 'ABR_2020-2021'[Reseller Code] ),[TO upto 80%], DESC )

)

)

[vs_7]

Hi @amitchandak 

i have tried below dax for count of partners.

but im not getting count 0f 50%,80% of partners from below dax

please help

count1 = COUNTROWS(filter(SUMMARIZE(sales,Sales[PARTNERCODE],"%p",[Total Revenue]),[Total Revenue]<99.99))

[v-rongtiep-msft]

Hi  @vs_7 ,

I am not sure if I unstderstand your meaning correctly.

Create measures.

Measure = CALCULATE(SUM('Table'[NETVALUE]),FILTER(ALL('Table'),'Table'[Quarter]=SELECTEDVALUE('Table'[Quarter])))

cummulative sales = CALCULATE(SUM('Table'[NETVALUE]),FILTER(ALL('Table'),'Table'[Quarter]<=SELECTEDVALUE('Table'[Quarter])))

If I have misunderstood your meaning, please explain what is your desired total sales and  cummulative sales .

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-rongtiep-msft]

Hi @vs_7 ,

Could you please tell me the output you want?  I'm not very clear on this. What is the calculation for 116, 579,6067 and so on?

By calculating the sales value and what is the value to the percentage?

If it is possible, please provide your desired output and pbix without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vs_7]

Hi @v-rongtiep-msft 

As per below screenshot ,i required below output as count of partners as per below sales data.

But im not getting the total sales and  cummulative sales to retrive the output.

Date	C Month Num	C Year	F Year	Quarter	Display Year	Month Name	PARTNERCODE	NETVALUE	Unit	Unit Values	Sort
01-05-2019	5	2019	2019	Q1	2019-2020	January	MY05I23485	47042.44	CR	10000000	3
02-05-2019	5	2019	2019	Q1	2019-2020	January	MR05I21910	51750.32	Lac	100000	2
03-05-2019	5	2019	2019	Q1	2019-2020	January	MR05I21910	28525.18	K	1000	1
04-05-2019	5	2019	2019	Q1	2019-2020	January	30APP04100	21070.3
05-05-2019	5	2019	2019	Q1	2019-2020	January	30APP04100	30000
06-05-2019	5	2019	2019	Q1	2019-2020	January	FI05A19162	900
07-05-2019	5	2019	2019	Q1	2019-2020	January	FI05A19162	62819.11
08-05-2019	5	2019	2019	Q1	2019-2020	January	FI05A19162	50391.09
09-05-2019	5	2019	2019	Q1	2019-2020	January	30ANA04100	88000
10-05-2019	5	2019	2019	Q1	2019-2020	January	RETAIL4100	2098.36
01-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	20800
02-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	22500
03-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	6250
04-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	557839.98
05-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	89640
06-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	1430047.94
07-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	480791.98
08-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	88375
09-07-2019	7	2019	2019	Q2	2019-2020	January	30LED04100	156000
10-07-2019	7	2019	2019	Q2	2019-2020	January	SYS05I6711	1671597.54
01-10-2019	10	2019	2019	Q3	2019-2020	January	SYS05I6711	815413.44
02-10-2019	10	2019	2019	Q3	2019-2020	January	SYS05I6711	2832489.18
03-10-2019	10	2019	2019	Q3	2019-2020	January	SYS05I6711	38610
04-10-2019	10	2019	2019	Q3	2019-2020	January	DA05I23887	930600
05-10-2019	10	2019	2019	Q3	2019-2020	January	FI05A19162	55276.2
06-10-2019	10	2019	2019	Q3	2019-2020	January	30SYS04100	80000
07-10-2019	10	2019	2019	Q3	2019-2020	January	30SYS04100	2450000
08-10-2019	10	2019	2019	Q3	2019-2020	January	30INT04100	8840000
09-10-2019	10	2019	2019	Q3	2019-2020	January	30INT04100	320000
10-10-2019	10	2019	2019	Q3	2019-2020	January	EG02I27433	4696530.55

[vs_7]

Hi @amitchandak 

As per below screenshot ,i required below output as count of partners as per above sales data.

But im not getting the total sales and  cummulative sales to retrive the output.

[amitchandak]

@vs_7 , Are you looking for top percentile ?

Top 80/20 , percent /percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/