Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
qmahieu11
Frequent Visitor

How to Group By a calculated measure?

I have created 3 measures linked to Id's. 
I'd like to group by one of this measure and having the count of Id's for each value of the measure.

Eg :  The table show Id, A calculated measure Connected member , a calculated measure engaged and a calculated measure Eng Rate

qmahieu11_0-1628723219693.png

code for one of the calculated measure:
```
Engaged Member = 

  var Lastmonth = [DateForSecondSlicer]
  var eom = EOMONTH([DateForSecondSlicer],0)+1
  var VideoSessionTable = SELECTCOLUMNS(
                                        FILTER(Videos,
                                                     Videos[Date] >= Lastmonth &&  Videos[Date] < eom &&
                                                     Videos[TotalSecondsWatched] >= 180), "WorkspaceId", Videos[d])
return
CALCULATE(COUNT(Users[UserOrganisation Id]),
                    FILTER(Users,
                                    AND(
                                              OR(AND(Users[Departed Date] < eom , Users[Departed Date] >= Lastmonth),
                                                     ISBLANK(Users[Departed Date]))
                                            ,Users[UserOrganisation Id] IN VideoSessionTable)
                       ))
```

The Desired Output would be to group by engagement rate and have the count of organisation Id's:
qmahieu11_1-1628723640293.png


Any idea how to get there?
Thanks for your help

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@qmahieu11 , What I got is that you need bucketing on engagement rate. For that, you need an independent table and measure based on. I explained these on blog and video, check that out

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@qmahieu11 , What I got is that you need bucketing on engagement rate. For that, you need an independent table and measure based on. I explained these on blog and video, check that out

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak Thanks for your solution, this worked!!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors