Forum Discussion
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.
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.
Hi v-chenwuz-msft ,
Is it possible to calculate maximum licenses used only for the dates selected in new table. For eg:
If user selects 14th Jan 2022, then all the time periods of that date should have maximum license value in new table
Is this possible? If yes, how?
Also, I am modifying my pbix file to keep only required data and will attach it shortly