cancel
Showing results 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

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

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:

Any idea how to get there?

1 ACCEPTED SOLUTION
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

2 REPLIES 2
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

Frequent Visitor

@amitchandak Thanks for your solution, this worked!!

Announcements

#### 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.

#### Power BI Monthly Update - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

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

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors