Forum Discussion
Get count by band
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 li...
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
v-yadongf-msft
Community Support
Community SupportHi 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.