Design a DBA Dashboard

[JIblasco]

Hi,

I'm trying to design a Dashboard to control the activity/errors/issues related to our databases. For this purpose, I have created a very easy table with only three columns. KPI, value and timestamp. My target is to create a simple panel (maybe with tarjet cards) that shows the last value of each KPI.

AS you can see, I'm saving in my table historical information, but I only want to show the las timestamp row of each KPI (marked in bold).

KPI	Value	timestamp
Average CPU time	10%	2020-08-20 09:20
Average CPU time	12%	2020-08-20 09:22
Average CPU time	2%	2020-08-20 09:24
Free Memory	70%	2020-08-20 09:21
Free Memory	75%	2020-08-20 09:22
Free Memory	10%	2020-08-20 09:24

Honestly, I have tried but I haven't found the way to do it. ¿Could you please help me?

Thanks in advance.

[Greg_Deckler · Accepted solution]

@JIblasco - You can create a selector for this

Selection selector for selection options

VAR __Max MAXX (ALL('Table'),[timestamp])

Return

IF(MAX('Table'[timestamp]) at __Max,1,0)

See Complex Selector - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

Also, maybe Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

[v-easonf-msft · Accepted solution]

Hi , @JIblasco 

As mentioned by @amitchandak  ,please create a calculated column:

Rank = RANKX(FILTER(ALL('Table'),'Table'[KPI ]=EARLIER('Table'[KPI ])),'Table'[timestamp],,DESC)

 And applied it to filter pane:

Best Regards,
Community Support Team _ Eason

[amitchandak]

@JIblasco , Take these two measures along with KPI in you visual

new timestamp = lastnonblank(table[timestamp],blank())
new Value = lastnonblankvalue(table[timestamp],max(Table[Value]))

Or create a Rank of time inside KPI and filter on 1

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[JIblasco]

Hi,

Thank you for your quick response. I have decided to create a view in the database with the las timestamp of each KPI. Anyway, thank you for the rank refers.

[Greg_Deckler · Accepted solution]

@JIblasco - You can create a selector for this

Selection selector for selection options

VAR __Max MAXX (ALL('Table'),[timestamp])

Return

IF(MAX('Table'[timestamp]) at __Max,1,0)

See Complex Selector - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

Also, maybe Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434