Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have found that to get percentile for counts based off day/hour I have needed to group by days or hours and do the counts in advance of doing the percentile calc or it would not work. Is there a better way to do this so that slicers will work or do I just have to create tables for each percentile slicer?
IE:
a table with multiple events on a day and I need to see the counts per day and per hour.(date and hour are already split out to their own columns).
Hopefully this makes sense, but it just seemed weird that average/mode/median work great, but percentile doesn't behave the same way.
Solved! Go to Solution.
Hi @StilHopen,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Everything is always based on filter context, especially when it comes to implicit measures. Don't like that? Write explicit measures. That will allow you to define the scope for your percentiles (with the option to override the filter context)
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |