Forum Discussion
reynold522
Helper II
3 years agoHelp needed in table like solution for notification purpose
Hi all, We have installed many IoT devices for battery voltage and current monitoring purpose. a lot of Power BI measures (e.g., SoC boundaries) are created for threshold purpose. as you can s...
amitchandak
Super User
3 years agoreynold522 , Not very clear, You can create a measure or column as per need
measure =
Switch(True(),
Max(Table[IoT ID]) = "1122" && Sum(Table[Value]) > 50000,1,
//Add other values
)
Column =
Switch(True(),
Table[IoT ID] = "1122" && (Table[Value]) > 50000,1,
//Add other values
)