Forum Discussion
Solved
Top 2 tasks by month
Hi, I have to get top 2 tasks by month starting from august 2017-now. When I'm using the top n filter it's giving me common top 2 tasks for all the months. I need top 2 tasks for that particular ...
Hi tulsi
You may try to add a rank measure as below. Then drag it to visual level filter and set the measure is less than or equal to 2. If it is not your case, please share some data sample.
Rank = RANKX ( ALL ( Table[task name] ), CALCULATE ( SUM ( Table[Qty] ) ) )
Regards,
Cherie
Hi tulsi
You may try to add a rank measure as below. Then drag it to visual level filter and set the measure is less than or equal to 2. If it is not your case, please share some data sample.
Rank = RANKX ( ALL ( Table[task name] ), CALCULATE ( SUM ( Table[Qty] ) ) )
Regards,
Cherie
It worked! Thank you!!!