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:
Absolutely, attached a sample file:
https://drive.google.com/file/d/1J_XdL6Zi1Z5x0aqBIr54lYvuUrX32Xpg/view?usp=sharing
Hi,
Given the buckets that you have in the support category table, 1,652 should fall in Category C (total of shipment number 1098 and 1250). Shipment number 1167 does not fall in any category/bucket. This is the measure i wrote
category_abcProfitEurr v1 = CALCULATE([measure_job_totalProfitEur],FILTER(ADDCOLUMNS(VALUES(SampleData[ShipmentNo]),"ABCD",CALCULATE([measure_job_totalRevenueEur],CALCULATETABLE(VALUES(SampleData[ShipmentID]))),"EFGH",CALCULATE([measure_job_totalProfitEur],CALCULATETABLE(VALUES(SampleData[ShipmentID])))),COUNTROWS(FILTER(Support_Category,[ABCD] >= Support_Category[RevenueLowerBoundaries] && [ABCD] < Support_Category[RevenueUpperBoundaries]&&[EFGH]>=Support_Category[ProfitLowerBoundaries]&&[EFGH]<Support_Category[ProfitUpperBoundaries])) >0))
Ashish_Mathur thanks but you see that the same value appears for A and B? this is the behaviour that I do not want, I would like it to show only A.
You are welcome. My formula will work absolutely fine once you correct categories table.