Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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])...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    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's avatar
    Anonymous
    5 years ago

    Cool !! That worked

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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