79230176

Date: 2024-11-27 12:04:22
Score: 1
Natty:
Report link

you can try to create a alarmband table like below.

enter image description here

then create a measure

MEASURE =
VAR _total =
    SUM ( 'customer alarm'[CountofAlarm] )
RETURN
    IF (
        _total >= MAX ( AlarmBands[left] )
            && _total <= MAX ( AlarmBands[right] ),
        _total,
        0
    )

enter image description here enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
Posted by: Ryan