Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Ola gostaria de uma ajuda para colocar uma medida que filtre apenas um valor especifico.
Exemplo: tabela pressão_caldeira mostre apenas os valores que utrapassar 9.5 bar.
E contabilize quantas vezes ultrapassou o nivel de 9.5, preciso de dicas ou algum material para que eu consiga prosseguir.
Solved! Go to Solution.
HI @Anonymous,
It sounds like you want to highlight the records that pressure over 9.5 and get the count of rolling alerts, right?
If that is the case, you can check the below formulas if help:
Highlight =
VAR currPresure =
CALCULATE ( MAX ( Table[pressão_caldeira] ), VALUES ( Table[E3Timestamp] ) )
RETURN
IF ( currPresure >= 9.5, Y, N )
Rolling alert count =
VAR currTS =
MAX ( Table[E3Timestamp] )
RETURN
COUNTROWS (
FILTER (
ALLSELECTED ( Table ),
[pressão_caldeira] >= 9.5
&& [E3Timestamp] <= currTS
)
)
Regards,
Xiaoxin Sheng
HI @Anonymous,
It sounds like you want to highlight the records that pressure over 9.5 and get the count of rolling alerts, right?
If that is the case, you can check the below formulas if help:
Highlight =
VAR currPresure =
CALCULATE ( MAX ( Table[pressão_caldeira] ), VALUES ( Table[E3Timestamp] ) )
RETURN
IF ( currPresure >= 9.5, Y, N )
Rolling alert count =
VAR currTS =
MAX ( Table[E3Timestamp] )
RETURN
COUNTROWS (
FILTER (
ALLSELECTED ( Table ),
[pressão_caldeira] >= 9.5
&& [E3Timestamp] <= currTS
)
)
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |