Calculation per ABC Classification

[Anonymous]

Hi everyone,

I have a succesfully created a dynamic measure that classifies the products in a given filter context into A, B and C based on their sales.

Now, my goal is to make calculations/visualizations based on each class, for example I want to visualize the net revenue per week in a line chart splitted into 3 lines, for A, B and C, however I am only able to put this measure into the tooltip, not in the legend:

Line Chart

Is this possible? If not, what approach would you suggets?

Thanks in advance!

@amitchandak 

[Ashish_Mathur]

Hi,

Share the download link of your PBI file with your DAX formulas intact so that i can understand your logic.

[lbendlin · Accepted solution]

create three separate measures.