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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

 

 

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

 

 

@amitchandak Thanks for your solution, this worked!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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