Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I have a MEASURE : Max Trip ,
It contains values :"Monday", "Tuesday" , "Wednesday" , "Thursday" , "Friday" , "Saturday" , "Sunday".
i want a measure which counts the ouccrence of them as below image :
| Max Trip | Occurence |
| Monday | 2 |
| Wednesday | 1 |
| Monday | 2 |
| Friday | 1 |
| 4 |
Solved! Go to Solution.
you need Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
text example
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q
you need Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
text example
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q
Can you please drop the code for this , it will be really helpful!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 18 | |
| 11 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 26 | |
| 21 | |
| 14 | |
| 12 |