Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
2 years ago

Conditional Dynamic Dax Segregation on customer

Hi All , I am expecting Help on this to achive this logic I need to segregate user into three categories Active Customer, Super Active Customer,Hyper Active Customer Based on the year and mon...
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Why has UserID 300004579 been classified as "Super Active Customer"?  The minimum login value of this customer is 1,2.  Share raw data in a format that can be pasted in an MS Excel file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hai Ashish_Mathur 

    Customer 300004579 login count is greater than 3 and if the minimum value is 3 or 4 for selected 6 months

    Then that customer should be super active customer

    So based on this condition I can say mentioned customer is super active , we can categorise while seeing login count of this user's data

     

    I will provide you the sample data of this

    But big thanks Ashish_Mathur  your response

    I will provide you the data

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      You are welcome.  I am confused.  For that customer, the minimum count is 1 and therefore he should be Active not Super Active.

  • AlanP514's avatar
    AlanP514
    Post Patron
    2 years ago

    Hai Ashish_Mathur 
    As you said i am pasting mock data
    Please find attached excel sheet , and please let me know the solution for achiving this customer segmentation based on the selection

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Since you have still not clarifies my previous doubt (asked yesterday), even if i download the file, i will not be able to help you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Ashish_Mathur 

        Yes, As you mentioned the user 300004579

        Is should be in active customer not in super active because the minimum value is 1 

         

        Kindly have a look on the Excel sheet which I attached as mock data aswell as the logic 

        It would be great if you could provide solution on this

         

         

        Regards

        Alan p

  • AlanP514's avatar
    AlanP514
    Post Patron
    2 years ago

    Hi   Ashish_Mathur 
    ,yes as u said the customer  300004579 should be active customer only, i mistakenly mapped to super active customer, 
    i am attaching segregation conditon, kindly have a look and let me know if you have any queries , and please provide solution 


    1 . Active Customer =  if the Count of Login time is greater than equal to 1 for the entire selected 6 months and if minimum value is (1 ,2)then that user is active customer
    2. Super Active Customer =  if the Count of Login time is greater than equal to 3 for the entire selected 6 months and if minimum value is 3 or 4 then that user is Super active Customer
    3.Hyper Active Customer =  if the Count of Login time is greater than equal to 5 for the entire selected 6 months and if minimum value is 5 then that user is Hyper active Customer

    Regards,
    Alan P James
    https://www.linkedin.com/in/alan-p-james-76b6aa16a/




    Ashish_Mathur

  • AlanP514's avatar
    AlanP514
    Post Patron
    2 years ago

    Hi Ashish_Mathur ,
    I hope you are clear with query, Kindly let me know if you have doubt still
    Regards
    Alan 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      I suggest you start a new thread.