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...
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,

bigfun's avatar
bigfun
Helper I
3 years ago

Curious if you have even put a condition on a switch statement.. For example:

I have a column that has a version# 1.0, 2.0, etc, and I only want to run the switch statement on the rows that are version 2.0.

rsbin's avatar
rsbin
Community Champion
3 years ago

bigfun ,

You can try this a couple of different ways:

LevelofActivity = SWITCH(
                      TRUE(),
                      [Version#] <> 2.0, Blank(),  // or "Not Applicable" or whatever....
                      [Monthly Logins] > 10, "High",
                      [Monthly Logins] >=5, "Medium",
                      "Low" )

If that doesn't work, then apply the condition to each line of conditions:

LevelofActivity = SWITCH(
                      TRUE(),
                      [Version#] = 2.0 && [Monthly Logins] > 10, "High",
                      [Version#] = 2.0 && [Monthly Logins] >=5, "Medium",
                      [Version#] = 2.0 && [Monthly Logins] < 5  "Low" )