This is high level stuff you are teaching, thank you for taking the time to do this!
@kuuuyajim
4 ай бұрын
I know how to do the calculation in my head as I've been doing it in Excel however, I was having trouble translating it into DAX. Your tutorial definitely helped putting it into perspective. Also, I'm glad there is already DAX Query View in Power BI, which really helped in visualizing the virtual tables.
@고독한승부사-m5x
Жыл бұрын
I am Korean. Thank you for sharing such good data.
@ExcelFort
Жыл бұрын
Glad you like it
@DominiqueToretto70
10 ай бұрын
You are very clever Great job
@ExcelFort
10 ай бұрын
Thank you! Cheers!
@AliKhan-nt3cm
2 жыл бұрын
Trillion thanks to you I was looking for this desperately from last three day
@ExcelFort
2 жыл бұрын
Glad it was helpful
@jessykms
2 жыл бұрын
Thanks, this solution help me a lot, I spent a lot of time trying to solve the ties error. Great vidio!!! :)
@ExcelFort
2 жыл бұрын
Glad it was helpful
@damiamquimtana573
11 ай бұрын
Great videos, you have teach me a lot. I have one request, is there any way to return the sum of only the highlited values???
@ExcelFort
11 ай бұрын
Yes, it is possible. Add the following measure : Complaint Count up to Threshold = VAR __TH = [Pareto Threshold Value] RETURN SUMX( FILTER( ADDCOLUMNS( ALLSELECTED( CompaintsData[Complaint]), "Pareto" , [Pareto %], "ComplainCount" , [Complaints Count] ), [Pareto]
@luckypondling
Жыл бұрын
Thank you -- this is genius! Of course my data had millions of ties, it's always that way 😅
@ExcelFort
Жыл бұрын
You are welcome 🙏
@jasongabriel8086
2 ай бұрын
Um Semi-Deus! Muito bom!
@JWSpradlin
5 ай бұрын
This is amazing. Unfortunately this gets extremely computationally expensive in my scenario. I am ranking warehouse picks by material, and just so far in 2024 I have 2,653 unique part numbers. This measure works out great, and the tie-breaking works well. What I am unable to figure out is a second measure to calculate the number of materials where the Pareto % is less than or equal to 80%: Pareto Material Count = CALCULATE( DISTINCTCOUNT('WarehousePickTable'[Material]), FILTER( 'WarehousePickTable', [Pareto %] >= 0.8 ))
@lionels839
3 ай бұрын
Hello The RANK function solves the TIE problem without the trick (second RANKX with division 10000000)
@lawrenceprado7169
2 жыл бұрын
You are a lifesaver
@ExcelFort
2 жыл бұрын
Thanks 🙏
@samiaelaboud9847
Жыл бұрын
Thank you for this great video! I'm wondering, if instead of highlighting on the chart the complaints accounting for the chosen threshold we want to count the number of complaints contributing to the chosen threshold, how would we do it? For example: I want ameasure to return the number 4 if the complaints are: Order mix_up, website not working, absence of modes of payments, long wait time.... Thanks!
@radivi2009
2 жыл бұрын
Great Video, one question- wondering why MAXX was used in line 12 instead of MAX (for variable __CurrCompPos ), as there is no row level iteration happening for table __CompTable.
@ExcelFort
2 жыл бұрын
Good question! __CompTable is a table variable, to extract a value from a column in a table variable, you need to use an iterator function. MAX would work if you refer to a physical table. Hope it made sense.
@scharan3749
Жыл бұрын
Hello thank you! But I still have one question left, how do I save the pareto threshold value. I did it with SELECTEDVALUE, but this only works for a slicer which is not between, >= or
@christianortino2701
2 жыл бұрын
Excelent!! I’m trying to download but the link doesn’t work. Could you please upload again? Thanks a lot!! Regards
@ExcelFort
2 жыл бұрын
Hi I checked it and it works. Please visit the link in the description, it will take you to my blog, provide your email ID and click download
@dharanidhar4875
2 жыл бұрын
Excellent, have a doubt,can we do drill down in this pareto chart, I tried it but failed to get the correct result, can you do with existing dataset
@josephetorne7226
Жыл бұрын
my only problem with using ADDCOLUMNS with the pareto measure is that when a subcategory is present in the model and it is being filtered, i'm getting a blank. i had to use SUMMARIZE to fix that.
Пікірлер: 29