TOP 5 OR TOP 10 in a Measure Calculated Visual

[Anonymous]

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])

Below is the visual I have.

Now I need to filter it as TOP10 or TOP 5 of the values in Call Rate that is a measure

How can I do it ?

[themistoklis · Accepted solution]

@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:

[Anonymous]

@nvprasadand @themistoklis - I do know that particular prodeure, but with a measure calculated value its not possible. The top option is not available.

The below is how it appears :

[themistoklis]

@Anonymous 

The filter must be applied on a categorical field not on call rate directly.

Call rate will be used to filter the data. In the image that I sent Order Qty was the categorical field and Call Rate was the measure.

So check the lowest granularity categorical field on table and filter it based on Call Rate

This video will help you

https://www.youtube.com/watch?v=veYjbBEgeQ8

[nvprasad]

Hi,

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:

https://www.oreilly.com/library/view/mastering-microsoft-power/9781788297233/378a5195-3e98-4cc1-bcd3...

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[themistoklis · Accepted solution]

@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:

[Anonymous · Accepted solution]

Cool !! That worked