Forum Discussion
Getting maximum concurrent license usage only
Anonymous You can add a measure into the Filters on this visual section of the Filters pane.
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 asmeasuredd 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.
Hi v-chenwuz-msft ,
Thankyou for the reply but I did not understood this part " store it in the cache as a calculation table to improve performance." Is there any technote or any example of how to do this?
Hi Anonymous ,
That means create a new table in power bi data. In power bi, you can use DAX to create columns or measures.
Columns
Power BI calculates and saves the results when the user has finished writing the dax immediately.
Measures
Power BI calculates result depend on the current content when the user uses this measure.
As you said, "it will do calculation for 30 days*86400=2592000 rows which is not a feasible option.", so, creating a new table or column in advance, rather than adding this table as a procedure table in the measure, will improve performance.
Then create a measure i have posted for filter pane.
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.
