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.
Hi Community,
I' m struggling with making this measure static for a specific month-year combination:
Top 100 April =
calculate(
[Values],
filter(datetable,MONTH(datetable[Date])=4),
filter(datetable,year(datetable[Date])=2018),
FILTER( values(Users[Name]) ,
rankx ( all( Users[Name]) , [Values] , , desc ) <=100)
)
I need to add the bolded filters inside the last filter so that it would rank users by value in April - 2018, but nothing has worked so far. Currently it ranks users by value at all time, and then calculate value of these users in 4-2018.
I' d appreciate some tips! Thank you,
Gvido
Solved! Go to Solution.
Hi GvidoB,
Modify the measure like below and check if it can work.
Top 100 April = RANKX ( ALL ( users ), CALCULATE ( [Values], FILTER ( datetable, MONTH ( datetable[Date] ) = 4 && YEAR ( datetable[Date] ) = 2018 ) ), , desc )
Regards,
Jimmy Tao
Hi GvidoB,
Modify the measure like below and check if it can work.
Top 100 April = RANKX ( ALL ( users ), CALCULATE ( [Values], FILTER ( datetable, MONTH ( datetable[Date] ) = 4 && YEAR ( datetable[Date] ) = 2018 ) ), , desc )
Regards,
Jimmy Tao
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |