Get count by band

[Anonymous]

Hi,

I have a table with one record for each login. 

I have a measure calculating how many logins per user. It gets filtered by a date slicer.

I have now some login bands:

What I would like to achieve is to see dynamically how many users per account are in each band each month. 

How do I achieve this?

[v-yadongf-msft]

Hi @Anonymous ,

This is my test table:

Please try following DAX:

Band range = [Logins greater than ]&"-"&[or eaqual to]

Month = SWITCH(
    TRUE(),
    MONTH('Table'[Date])=1,"Jan",
    MONTH('Table'[Date])=2,"Feb",
    MONTH('Table'[Date])=3,"Mar")

Count of Band range = COUNT('Table'[Band range])

You can create a table visual like below to see dynamically how many users per account are in each band each month.

Please feel free to let me know if I misunderstood your demands.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Are you looking for dynamic segmentation?

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

this example use more than one group by

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY