Forum Discussion

Okazakipedro's avatar
Okazakipedro
Icon for Helper I rankHelper I
2 years ago
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 ...
Need Help
  • pbiuseruk's avatar
    pbiuseruk
    2 years ago

    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:

     

Okazakipedro's avatar
Okazakipedro
Icon for Helper I rankHelper I
2 years ago

Hello pbiuseruk  good afternoon.


Yes, I tried that and know that the issue is in the OR clause (since based on profitability it would fall in one category and based on revenue on another)... The issue is that I could not find a way to return only one category and prioritize the upper one (A->B-> C)...

Thank you for the input 🙂

pbiuseruk's avatar
pbiuseruk
Icon for Resolver IV rankResolver IV
2 years ago

If you can see there's multiple values being returned in the table and you only want one based on precedence, then you'd need to do an if or switch condition in the Result variable. e.g. If category A exists, then take value A, if Category B exists then take value B, etc... 

  • Okazakipedro's avatar
    Okazakipedro
    Icon for Helper I rankHelper I
    2 years ago

    Hello, the issue here is that the columns are A,B,C And the Measure is bringing the profitability, I can't do a switch case...

     

    VAR SalesByProduct =
        CALCULATETABLE (
            ADDCOLUMNS (
                SUMMARIZE ( SampleData, SampleData[Controlling Customer Code] ),
                "@ProdSales", [measure_job_totalProfitEur]
            ),
            ALLSELECTED ( SampleData )
        )
     
    This is what is bringing the profitability.