Forum Discussion
Pareto Chart
Anonymous , Please use Window function for that, yiu can easily break ties using order by
Cumm = CALCULATE( DISTINCTCOUNT('Aircraft Records'[Investigation Report No. (INV)]), Window(1,ABS,0,REL, ALLselected('Aircraft Records'[category]),ORDERBY( DISTINCTCOUNT('Aircraft Records'[Investigation Report No. (INV)]),desc,'Aircraft Records'[category], asc )))
Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f
Or try with Range Visual level funtion
🚀 Master Visual Calculations in Power BI- February 2024 Update RUNNINGSUM, RANGE, MOVINGAVERAGE, COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL, FIRST, LAST, PREVIOUS, and NEXT
https://www.youtube.com/watch?v=bKD9T0EWgQo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
Super UserAnonymous , Please use Window function for that, yiu can easily break ties using order by
Cumm = CALCULATE( DISTINCTCOUNT('Aircraft Records'[Investigation Report No. (INV)]), Window(1,ABS,0,REL, ALLselected('Aircraft Records'[category]),ORDERBY( DISTINCTCOUNT('Aircraft Records'[Investigation Report No. (INV)]),desc,'Aircraft Records'[category], asc )))
Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f
Or try with Range Visual level funtion
🚀 Master Visual Calculations in Power BI- February 2024 Update RUNNINGSUM, RANGE, MOVINGAVERAGE, COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL, FIRST, LAST, PREVIOUS, and NEXT
https://www.youtube.com/watch?v=bKD9T0EWgQo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
Hi Amit,
I've tried the formula that you have provided but the values are not correct.