Forum Discussion
Helper IHow can I do an ABC Analysis, where each category is a Column instead of measure?
Hello all, good morning.
Been stuck with this analysis for almost one week. I am currently performing an ABC analysis for all customers in the company. The issue is that creating a measure that define the category by customer is easy, but I can't create a graph showing the total for a category since A,B,C is the measure.
My approach was creating another table with the categories and create a measure that would sum the total for each category, but no luck so far. Here is the link to the file and my measure.
https://drive.google.com/file/d/1J_XdL6Zi1Z5x0aqBIr54lYvuUrX32Xpg/view?usp=sharing
My issue is that based on the boundaries, a customer can be categorized as B due to revenue and A due to profit, but I dont want to show both options and just maintain the first one... Currently my measure assigns to both , based on the PBI attached.
Does anyone know how to solve it?
2 Replies
- lbendlin
Super User
Change your B measure to return BLANK if the A measure yields a result, or use TOPN(1)
Your sample data is not covering your scenarios. Please provide better sample data.
sio2GraphsHello,
You can use visual "Pareto+" to create the graph, table and legend. You can also use "Pareto by sio2Graphs" to produce the graph.
I made some assumptions and added data to demonstrate the basic idea. You can grab the “SampleData.pbix” from Git.
sio2Graphs 😀
