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,

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

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" )