Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
vs_7
Responsive Resident
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.

 

vs_7_0-1644915941627.png

 

 

output

 

vs_7_1-1644916078588.png

 

7 REPLIES 7
vs_7
Responsive Resident
Responsive Resident

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
Responsive Resident
Responsive Resident

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

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.

 

 

v-rongtiep-msft
Community Support
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.

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.

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   

 

vs_7
Responsive Resident
Responsive Resident

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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.