Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey guys,
What would be the best way to achieve the following example?
Count of Unique Employees | |
0%-25% | 10 |
25%-50% | 15 |
50%-75% | 55 |
75%-99% | 25 |
100% | 10 |
UniqueID | CourseID | Status |
g5hfg6hg54 | sadad223 | Completed |
g5hfg6hg54 | asda3166 | Not Started |
as6d54a6s54 | asda3166 | Completed |
as5d6asd566 | asda1656 | Not Started |
dsd6f45d677 | dsada215 | Not Started |
Count of Unique Employees | |
0%-25% | 2 |
25%-50% | |
50%-75% | 1 |
75%-99% | |
100% | 1 |
Many many thanks in advance,
AC.
Solved! Go to Solution.
Are you expecting something like this:
It hides some complexity, we would need to create a segment table like below:
Based on the Segment table and the orginal Data table, we could get your expected table with a calculated table with the code below:
Hi @drakwen ,
Looking forward to your next reply. If you validate that the method provided by @FreemanZ and @amitchandak can help you get the solution later, could you please mark it as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
Are you expecting something like this:
It hides some complexity, we would need to create a segment table like below:
Based on the Segment table and the orginal Data table, we could get your expected table with a calculated table with the code below:
Hi @FreemanZ and @amitchandak
I tried both your methods and both return the samer result, two equal results split into two ranges 25%-50% and 75%-99% for 297. I know that my actual result should be around 6k, so I will try this week to limit the database to 1000 results and play until I discover what is going on with my data, because I am pretty sure both your answers are correct.
Many thanks for both your replies, I'll keep you posted.
Hi @drakwen ,
Looking forward to your next reply. If you validate that the method provided by @FreemanZ and @amitchandak can help you get the solution later, could you please mark it as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
I confirm it now works!! It was my data that was failing
@drakwen , You need dynamic segmentation for that
Divide( Count(filter(Table[Status] ="Completed"), Table[CourseID]) , Count(Table[CourseID]) )
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |