Forum Discussion
Conditional group dax
I am trying to create conditional group or bin based on the measure I need to segragte all customer into three Hyper active Super Active Active I Have created count of user who has logg...
You can try the following measure
CustomerCategory =
VAR TotalLogins = [Logins]
RETURN
SWITCH ( TRUE (),
TotalLogins >= 5, "Hyper Active",
TotalLogins >= 3 &&
TotalLogins <= 4, "Super Active",
TotalLogins >= 1 &&
TotalLogins <= 2, "Active",
BLANK ()
)