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.

Responsive Resident

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

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

i am using sales table which is fetching from S4HANA.

output

7 REPLIES 7
Responsive Resident

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

Responsive Resident

i have tried below dax for count of partners.

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

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

Community Support

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.

Community Support

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.

Responsive Resident

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

Responsive Resident

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.

Super User

@vs_7 , Are you looking for top percentile ?

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors