Forum Discussion
TOP 5 OR TOP 10 in a Measure Calculated Visual
Hi, I have a measure which calculates a column called Call Rate Call Rate with Month = DIVIDE(DIVIDE(CallReport[No. of Calls in Building],[No. of Units in Building]),[Call Rate Month Count])...
Anonymous
Have you tried using the filter pane to filter the Top N.
You should go to the field on filter pane where the Top N will be applied.
Then add the measure Call rate so as to filter the records by the value.
See image below:
Cool !! That worked
nvprasad
Solution Sage
Solution SageHi,
You can use Topn filter in the filter pane on any categorical value. ( go to filter pane, select top n from the dropdown then use cell Rate measure and apply.
Refer:
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad