Forum Discussion

bigfun's avatar
bigfun
Helper I
3 years ago
Solved

Measure to Segment User Activity

I created a measure that totals up 'Logins' per clientID a month.

 

Monthly Logins = calculate(DISTINCTCOUNT(ui_PageActionView[UnqSession]), DATESINPERIOD('Calendar'[Date],max('Calendar'[Date]),-1,MONTH))
 

 

But now I want to create another measure that assigns a 'level of activity' based on the # of monthly logins

Low = less than 5
Medium = between 5 - 10

HIgh = 10+

 

I believe I need to create it using a switch but I'm not sure how to set it up.

 

 

 

Need Help
Show and Tell
  • rsbin's avatar
    rsbin
    3 years ago

    bigfun ,

    Yes, SWITCH Statement is how I would approach this as well:

    LevelofActivity = SWITCH(
                      TRUE(),
                      [Monthly Logins] > 10, "High",
                      [Monthly Logins] >=5, "Medium",
                      "Low" )

    The last line, is your "else" condition.  You can specify your third condition <5 if you want to make it clearer to yourself or others.

    Hope this helps.

    Regards,

7 Replies

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    bigfun ,

    Yes, SWITCH Statement is how I would approach this as well:

    LevelofActivity = SWITCH(
                      TRUE(),
                      [Monthly Logins] > 10, "High",
                      [Monthly Logins] >=5, "Medium",
                      "Low" )

    The last line, is your "else" condition.  You can specify your third condition <5 if you want to make it clearer to yourself or others.

    Hope this helps.

    Regards,

    • bigfun's avatar
      bigfun
      Helper I
      3 years ago

      This is perfect... now I just need to figure out how to free up or not use as much memory processing it.. haha

      • rsbin's avatar
        rsbin
        Community Champion
        3 years ago

        bigfun ,

        Glad I could help.  I use SWITCH throughout all of my numerous reports.  Have never had an issue with memory or resources.  Perhaps something else in your model is causing this.  Unfortunately, this is out of my scope.

  • bigfun's avatar
    bigfun
    Helper I
    3 years ago

    So i am not sure why... But all the 'Activity Status' are showing low... I'm not sure why it isn't evaluating the number and assigning the status correctly.

     

    Sample File

    • rsbin's avatar
      rsbin
      Community Champion
      3 years ago

      bigfun ,

      The LevelofActivity is written as a Measure not a Calculated Column.

      If you drag this Measure into your Visual in your Original Post, it should work as intended.

       

      As a Calculated Column, it is evaluating each Row to 1, hence "low".  I believe this is what's happening.