Forum Discussion
STATIC Classification ABC
Hi,
The only way to make it static is to write calculated column formulas. I think it will be easier to solve this question by writing measures but that would make the classification dynamic.
I've upload this simple table :
What I want is to classify in PowerBI all of my products based on the sales (pareto rule) (ABC classification).
My output is for every Product, I want to have a new classification "A" / "B" or "C" .
Output example :
| Product | Total Sales | Cumulated Sales | Cumulated Percentage | ABC |
| A1 | 100 | 100 | 55% | A |
| A2 | 50 | 150 | 83% | B |
| A3 | 20 | 170 | 94% | B |
| A4 | 10 | 180 | 100% | C |
- To be calculated in Power BI
I also want it to be static : when I use a slicer in Power BI I do not want this ABC to be dynamically adjust.
Thanks for your help !
Super UserHi,
The only way to make it static is to write calculated column formulas. I think it will be easier to solve this question by writing measures but that would make the classification dynamic.
It works, thanks a lot 🙂