Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have the following measure that is displaying more than TOPN. I want top 15 clients. I believe it's because I have YEAR and MONTH in my results. Ideally I'd like the top N to be based on the 2023 total and if that isn't possible then based on the grand total for each line of data.
@jajoerger , Create a measure like
Last Year = calculate(Sum(EmpTime_Clients[TotalHrs]) , previousyear(Date[Date])
Use this as visual level filter for TOPN filter
Or create another measure like
calculate(Sum(EmpTime_Clients[TotalHrs]) ,keepfilters(topn(10, allselected(EmpTime_Clients[Client]), [last Year], desc) ))
Power BI Tutorial Series for Beginners Part 42 TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
https://medium.com/microsoft-power-bi/power-bi-topn-others-8b094203a306
I'm not quite following 100%. Should I delete the measure (Top N Hours) that I created and create a new one?
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |