How can I do an ABC Analysis, where each category is a Column instead of measure?

[Okazakipedro]

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?

[sio2Graphs]

Hello, 

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 😀

sio2graphs on AppSource 

[lbendlin]

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.