Forum Discussion

Ana_Cardoso's avatar
Ana_Cardoso
Frequent Visitor
6 years ago
Solved

Idenfity peak

Hello all,  I have a dataset with Timestamp, TagName and KPIValue of multiple tags. And I need to count "alarms" that is when I had a peak on a curve by TagName. My alarm trigger is KPIValue >= 50. ...
Need Help
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Ana_Cardoso 

     

    Based on your description, you may create two measures as below.

     

     

    Alarm =
    var _currentvalue = SELECTEDVALUE('Table'[Value])
    var _currentdatetime = SELECTEDVALUE('Table'[Data Hora])
    var _currenttag = SELECTEDVALUE('Table'[Tag])
    var _lastvalue =
    CALCULATE(
    MAX('Table'[Value]),
    FILTER(
    ALLSELECTED('Table'),
    'Table'[Tag] = _currenttag&&
    'Table'[Data Hora] =
    CALCULATE(
    MAX('Table'[Data Hora]),
    FILTER(
    ALLSELECTED('Table'),
    'Table'[Tag] = _currenttag&&
    'Table'[Data Hora]<_currentdatetime
    )
    )
    )
    )

    return
    SUMX(
    'Table',
    IF(
    ISFILTERED('Table'[Data Hora]),
    IF(
    _lastvalue<50&&
    _currentvalue>50,
    1,
    0
    )
    )
    )

     

    Count =
    SUMX(
    'Table',
    [Alarm]
    )

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Ana_Cardoso 

 

Based on your description, I created data to reproduce your scenario.

Data:

 

You may create a measure as below.

Count =
var _datetime = SELECTEDVALUE(Data[Date])
return
COUNTROWS(
FILTER(
ALLSELECTED(Data),
Data[Date]<_datetime&&
Data[Value]>=50
)
)

 

 

 

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ana_Cardoso's avatar
Ana_Cardoso
Frequent Visitor
6 years ago

Hi, I've tried all the suggestions but none is what i need. 
I bring more informantion in order to try explain better what I want to count. First a table with samples of my data with a column "Alarm" wich is what I'm looking foward.

Data HoraTagValueAlarm
03/04/2020 03:40Tag 1100
03/04/2020 03:41Tag 1120
03/04/2020 03:42Tag 1601
03/04/2020 03:43Tag 1650
03/04/2020 03:44Tag 1300
03/04/2020 03:45Tag 1250
03/04/2020 03:46Tag 1591
03/04/2020 03:47Tag 1400
03/04/2020 03:48Tag 120
03/04/2020 03:49Tag 110
03/04/2020 03:43Tag 2490
03/04/2020 03:44Tag 2551
03/04/2020 03:45Tag 2590
03/04/2020 03:46Tag 2100

And an image where I put circles on the alarms. 

 It is continuos data. So, I have to count when I had a peak above 50 not the number of samples wich [Value] >=50.

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Ana_Cardoso 

     

    Based on your description, you may create two measures as below.

     

     

    Alarm =
    var _currentvalue = SELECTEDVALUE('Table'[Value])
    var _currentdatetime = SELECTEDVALUE('Table'[Data Hora])
    var _currenttag = SELECTEDVALUE('Table'[Tag])
    var _lastvalue =
    CALCULATE(
    MAX('Table'[Value]),
    FILTER(
    ALLSELECTED('Table'),
    'Table'[Tag] = _currenttag&&
    'Table'[Data Hora] =
    CALCULATE(
    MAX('Table'[Data Hora]),
    FILTER(
    ALLSELECTED('Table'),
    'Table'[Tag] = _currenttag&&
    'Table'[Data Hora]<_currentdatetime
    )
    )
    )
    )

    return
    SUMX(
    'Table',
    IF(
    ISFILTERED('Table'[Data Hora]),
    IF(
    _lastvalue<50&&
    _currentvalue>50,
    1,
    0
    )
    )
    )

     

    Count =
    SUMX(
    'Table',
    [Alarm]
    )

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Ana_Cardoso's avatar
      Ana_Cardoso
      Frequent Visitor
      6 years ago

      Hi, v-alq-msft It was just what I needed. It works perfectly.
      Thanks for the help. 

      Regards,

      Ana