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.
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!
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.
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.
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 ))
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.
This is high level stuff you are teaching, thank you for taking the time to do this!
I am Korean.
Thank you for sharing such good data.
Glad you like it
Trillion thanks to you
I was looking for this desperately from last three day
Glad it was helpful
You are very clever
Great job
Thank you! Cheers!
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.
Thanks, this solution help me a lot, I spent a lot of time trying to solve the ties error. Great vidio!!! :)
Glad it was helpful
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!
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 videos, you have teach me a lot.
I have one request, is there any way to return the sum of only the highlited values???
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]
Thank you -- this is genius! Of course my data had millions of ties, it's always that way 😅
You are welcome 🙏
You are a lifesaver
Thanks 🙏
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.
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.
Hello
The RANK function solves the TIE problem without the trick (second RANKX with division 10000000)
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
Excelent!! I’m trying to download but the link doesn’t work. Could you please upload again? Thanks a lot!! Regards
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
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
))
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.
Glad you found a way
Um Semi-Deus! Muito bom!
Ok❤