Reply
AlanP514
Helper V
Helper V
Partially syndicated - Outbound

Condtional Dax

AlanP514_0-1695808946086.png
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 logged in each month(Below is that measure)

Logins = Sumx(Facttracking, Fact tracking[Desktop count] +  Fact tracking[Mobile count] 

so i have added user in the row section of the pivot , month in the section of column name and login in the measure value
so according to the sum of all values aganist each month
if the total sum of the count value  >= 5 i need to segregrate those customer into hyper active
if the total sum of the count value  = 3,4 i need to segregrate those customer into Super  active
if the total sum of the count value  = 1,2 i need to segregrate those customer into   active




Appreatiate help on this to create dax

1 REPLY 1
lbendlin
Super User
Super User

Syndicated - Outbound

Create a separate table with your buckets.  Create a measure that assigns each of your data points to a bucket.  Use that disconnected table and measure in your visual.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)