Forum Discussion
Getting maximum concurrent license usage only
Anonymous Use MAXX, so something like:
Maximum Concurrent =
MAXX(
ADDCOLUMNS(
DISTINCT('DateTimeSec'[DateTime],
"Concurrent",[LicenseUsageSecJob]
),
[Concurrent]
)
You could then use the Filter pane or another selector measure to only show the rows where the value is the max.
My report looks like this(screenshot above). When the user selects a date the table on right displays the maximum concurrent calls for all the seconds for that day i.e. 86400 rowswhich the table visual is not able to display.
Now the key ask here is that how to show only those records in table visual which has maximum concurrent calls, it could be 30-40 rows for eg. and not 86400 rows for each second.
Greg_Deckler The measure shared by you when placed with datetime field in a table visual still gives all the seconds rows. Requesting your help!
Anonymous I think you missed this in the previous post "You could then use the Filter pane or another selector measure to only show the rows where the value is the max." So, try this:
Maximum Concurrent Flag = VAR __Max MAXX( ADDCOLUMNS( DISTINCT(ALL('DateTimeSec'[DateTime]), "Concurrent",[LicenseUsageSecJob] ), [Concurrent] ) VAR __Count = CALCULATE(COUNT(Jobs[Id]), FILTER(Jobs,( (SELECTEDVALUE(DateTimeSec[DateTime]) >= Jobs[StartTime] && SELECTEDVALUE(DateTimeSec[DateTime]) <= Jobs[EndTime])||(SELECTEDVALUE(DateTimeSec[DateTime]) >= Jobs[StartTime] && Jobs[EndTime] = BLANK())))) RETURN IF(__Count = __Max, __Count,BLANK())Filter pane does not accept Max function. Also, Var _Max calculates for all datetime and not selected value, hence it will do calculation for 30 days*86400=2592000 rows which is not a feasible option.