Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
(Link to the pbix: Pareto.pbix)
Hi. I've been struggling with this for a while. I've read a lot of answers and blogs but neither of those addressed an issue I'm having. The data:
The thing is, I need to filter this in the report with a couple of slicers (by Group and Date) so I CAN'T rank the defects in power query or with a calculated column (depending on the slicer I'll have to deal with different data).
Now, I've got this:
Using these measures:
Could someone help me to get the cummulative percentage for the pareto? The end result would be this:
Thanks.
Solved! Go to Solution.
@Anonymous
This can help you get what you need. I had the help of some friends to complete this but I now have three functioning paretos that can be filtered, cross filtered, and sliced/diced anyway I need it.
Proud to be a Super User!
Man I don't know how I didn't find that post...
It worked great! I didn't use your accepted solution though (didn't want to use SUMMARIZE, my table is much smaller anyways). I used this solution.
The new measures I used:
Thanks a lot for the help @kcantor.
@Anonymous
This can help you get what you need. I had the help of some friends to complete this but I now have three functioning paretos that can be filtered, cross filtered, and sliced/diced anyway I need it.
Proud to be a Super User!
Man I don't know how I didn't find that post...
It worked great! I didn't use your accepted solution though (didn't want to use SUMMARIZE, my table is much smaller anyways). I used this solution.
The new measures I used:
Thanks a lot for the help @kcantor.
You Rock! Thanks.
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |