Fixed Measure for specific field

[LuisGramillo]

Hi everyone,
I am currently working on the display of available time for bots, given the following master measure:
MAX( AGGR( 1-SUM(Hours) / ( COUNT(Day)*24 ) , Bot) )
I will like to set the maximum available time per bot and keep this value when specific bots are selected, I want to be filtereds by day, month or other fields different from Bots.

Do you know how to achieve this?

[Chanty4u · Accepted solution]

Try this 

MAX(

  AGGR(

    1 - SUM({<Bot=>} Hours) / (COUNT({<Bot=>} Day)*24),

    Bot

  )

)