Forum Discussion
Solved
Help with ABC Customer categorizing - DAX
Hello dear Desktop users, good morning. I am stuck in a DAX measure related to ABC Customer Segmentation. My current formula is as below, unfortunately the result brings 2 categories (A and B) I ...
Slightly confused what you're expecting (please explain) - this is the result I get when I add your existing measure with the new measure I made:
Could you try using this:
NewMeasure =
Var ControllingCustomerCode = SELECTEDVALUE(SampleData[Controlling Customer Code])
RETURN
CALCULATE(LASTNONBLANK ( Support_Category[Category], 1 ),
FILTER (
Support_Category,
[measure_job_totalProfitEur] > 'Support_Category'[ProfitLowerBoundaries]
&& [measure_job_totalProfitEur] <= 'Support_Category'[ProfitUpperBoundaries]
|| ( [measure_job_totalRevenueEur] > 'Support_Category'[RevenueLowerBoundaries]
&& [measure_job_totalRevenueEur] <= 'Support_Category'[RevenueUpperBoundaries] )
), SampleData[Controlling Customer Code] = ControllingCustomerCode
)
Then make a table with the company code, the measure for the euro amount and this new measure.
Please let me know if this is what you were after?
No, this is bringing the category A B and C instead of the profit
Slightly confused what you're expecting (please explain) - this is the result I get when I add your existing measure with the new measure I made: