Getting maximum concurrent license usage only

Hi Anonymous ,

You can start by creating an aggregate table to find the maximum value at each time, as Greg_Deckler  says _Max, and store it in the cache as a calculation table to improve performance.

Then create a measure, such as

measuredd if =
IF(
    [LicenseUsageSecJob]
        = CALCULATE(
            MAX( 'new table'[countjobs] ),
            'new table'[DateTime]
                = SELECTEDVALUE( DateTimeSec[DateTime] )
        ),
    1,
    0
)

put the measure in filter pane and set show item is 1.

You can share your pbix file without sensitive data if you need more help.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.