I am creating some metrics for our alarm system, and one of them revolves around alarm flooding. The definition of alarm flooding is where 10 or more alarms occur within a 10 minute period. I was able to create the 10 minute bins, and create a visual which shows the alarm flooding, and when it exceeds a certain limit. I need to however create KPIS which show things like:
Most of these metrics rely on having this measure available.
The chart I created looks like this:
The data looks like this:
Any help would be appreciated.
Hi @mitchy-06 ,
Could you please tell me the Floods related which column? Tag or ID? And could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490