Forum Discussion
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 =
Videos[TotalSecondsWatched] >= 180), "WorkspaceId", Videos[d])
```
The Desired Output would be to group by engagement rate and have the count of organisation Id's:
Any idea how to get there?
Thanks for your help
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
2 Replies
- amitchandak
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k- qmahieu11Frequent Visitor
amitchandak Thanks for your solution, this worked!!