SOLVED! Pareto Chart with TIES In Power BI | Step-By-Step Tutorial | Part 2 

This is high level stuff you are teaching, thank you for taking the time to do this!

You are very clever Great job

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.

I am Korean. Thank you for sharing such good data.

Trillion thanks to you I was looking for this desperately from last three day

Thanks, this solution help me a lot, I spent a lot of time trying to solve the ties error. Great vidio!!! :)

Thank you -- this is genius! Of course my data had millions of ties, it's always that way 😅

You are a lifesaver

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!

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

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

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

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.

Um Semi-Deus! Muito bom!

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

Hello The RANK function solves the TIE problem without the trick (second RANKX with division 10000000)

Excelent!! I’m trying to download but the link doesn’t work. Could you please upload again? Thanks a lot!! Regards

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.

Ok❤