Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Morning All,
I have an ABC analysis in a static normalised table that I created but I am now have issue where when I have just 2 items for a location,brand. The problem is that the segmentation does not give the results I need; either A/C or B/C because of the way the formual works when with cumulative percentage. I just need help writing a clause that says when there are 2 items for Location /Brand it just needs to be "A" and "B" based on the sales revenue and not on the cumulative percentage. Any help would be much appreciated.
This is the current calculated column I am using for the ABC segmentation.
ABC Product =
SWITCH (
TRUE,
ABC[Cumulated Percentage] <= 0.8, "A",
ABC[Cumulated Percentage] <= 0.95, "B",
"C"
)
Solved! Go to Solution.
Hope formula in the pic does ur job...Kudos
Hi @Mack1int,
To better illustrate your scenario, please share some sample data and show us your desired output.
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |