Help needed in table like solution for notification purpose

[reynold522]

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 see, column 1 is IoT ID, row 1 is all the measure titles

the initial value of this table is 0.

IoT ID	Measure 1 (1, if >50000 AGM )	Measure 2 (1,if >1.5)	Measure 3 (1, if <6.5)	Measure 4 (1, if >1.2)	Measure 5 (1,if >1.5)	Measure 6 (1,if >20%)	Measure 7 (1, if duration>1 hour)	Measure 8 (1,if SoC diff>20%	Measure 9 (1,if >80% for AGM)
1122	0	0	0	0	0	0	0	0	0
1133	0	0	0	0	0	0	0	0	0
12586	0	0	0	0	0	0	0	0	0
12598	0	0	0	0	0	0	0	0	0
13597	0	0	0	0	0	0	0	0	0
1130	0	0	0	0	0	0	0	0	0
1258	0	0	0	0	0	0	0	0	0

if Measure 1 of device with IoT ID 1122 has higher value than 50000, then it will turn into 1

if Measure 3 of device with IoT ID 12586 has smaller value than 6.5, then it will turn into 1

the corresponding change in the table is as following

IoT ID	Measure 1 (1, if >50000 AGM )	Measure 2 (1,if >1.5)	Measure 3 (1, if <6.5)	Measure 4 (1, if >1.2)	Measure 5 (1,if >1.5)	Measure 6 (1,if >20%)	Measure 7 (1, if duration>1 hour)	Measure 8 (1,if SoC diff>20%	Measure 9 (1,if >80% for AGM)
1122	1	0	0	0	0	0	0	0	0
1133	0	0	0	0	0	0	0	0	0
12586	0	0	1	0	0	0	0	0	0
12598	0	0	0	0	0	0	0	0	0
13597	0	0	0	0	0	0	0	0	0
1130	0	0	0	0	0	0	0	0	0
1258	0	0	0	0	0	0	0	0	0

in case, some value turn into 1, a notification regarding which category as well as IoT ID will be send to me

my question, what will be good solution for this table? to use "Summarize Function" from DAX to creat a dynamic table like this? 

thanks in advance!

[amitchandak]

@reynold522 , 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

)