Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vs_7
Continued Contributor
Continued Contributor

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

‎02-15-2022 01:09 AM

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

 

i am using sales table which is fetching from S4HANA.

 

vs_7_0-1644915941627.png

 

 

output

 

vs_7_1-1644916078588.png

 

Labels:
Message 1 of 8
437 Views
0
7 REPLIES 7
vs_7
Continued Contributor
Continued Contributor

‎02-21-2022 10:42 PM

Hi @Anonymous @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 )
)
)
 
 
 

 

Message 7 of 8
336 Views
0
vs_7
Continued Contributor
Continued Contributor
In response to vs_7

‎02-23-2022 10:37 PM

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

 

Message 8 of 8
317 Views
0
Anonymous
Not applicable

‎02-21-2022 10:17 PM

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

vpollymsft_0-1645510508475.png

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.

 

 

Number of partners for turnover upto 50%, 80%, 100%.pbix
Message 6 of 8
339 Views
0
Anonymous
Not applicable

‎02-18-2022 01:09 AM

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.

Message 4 of 8
351 Views
0
vs_7
Continued Contributor
Continued Contributor
In response to Anonymous

‎02-21-2022 09:27 PM

Hi @Anonymous 

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.

vs_7_0-1645507543459.png

DateC Month NumC YearF YearQuarterDisplay YearMonth NamePARTNERCODENETVALUEUnitUnit ValuesSort
01-05-2019520192019Q12019-2020JanuaryMY05I2348547042.44CR100000003
02-05-2019520192019Q12019-2020JanuaryMR05I2191051750.32Lac1000002
03-05-2019520192019Q12019-2020JanuaryMR05I2191028525.18K10001
04-05-2019520192019Q12019-2020January30APP0410021070.3   
05-05-2019520192019Q12019-2020January30APP0410030000   
06-05-2019520192019Q12019-2020JanuaryFI05A19162900   
07-05-2019520192019Q12019-2020JanuaryFI05A1916262819.11   
08-05-2019520192019Q12019-2020JanuaryFI05A1916250391.09   
09-05-2019520192019Q12019-2020January30ANA0410088000   
10-05-2019520192019Q12019-2020JanuaryRETAIL41002098.36   
01-07-2019720192019Q22019-2020January30APP0410020800   
02-07-2019720192019Q22019-2020January30APP0410022500   
03-07-2019720192019Q22019-2020January30APP041006250   
04-07-2019720192019Q22019-2020January30APP04100557839.98   
05-07-2019720192019Q22019-2020January30APP0410089640   
06-07-2019720192019Q22019-2020January30APP041001430047.94   
07-07-2019720192019Q22019-2020January30APP04100480791.98   
08-07-2019720192019Q22019-2020January30APP0410088375   
09-07-2019720192019Q22019-2020January30LED04100156000   
10-07-2019720192019Q22019-2020JanuarySYS05I67111671597.54   
01-10-20191020192019Q32019-2020JanuarySYS05I6711815413.44   
02-10-20191020192019Q32019-2020JanuarySYS05I67112832489.18   
03-10-20191020192019Q32019-2020JanuarySYS05I671138610   
04-10-20191020192019Q32019-2020JanuaryDA05I23887930600   
05-10-20191020192019Q32019-2020JanuaryFI05A1916255276.2   
06-10-20191020192019Q32019-2020January30SYS0410080000   
07-10-20191020192019Q32019-2020January30SYS041002450000   
08-10-20191020192019Q32019-2020January30INT041008840000   
09-10-20191020192019Q32019-2020January30INT04100320000   
10-10-20191020192019Q32019-2020JanuaryEG02I274334696530.55   

 

Message 5 of 8
345 Views
0
vs_7
Continued Contributor
Continued Contributor

‎02-15-2022 01:44 AM

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.

vs_7_0-1644917970413.png

 

Message 3 of 8
389 Views
0

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

View All