Forum Discussion
Helper IIHelp 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 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!
1 Reply
- amitchandak
Super User
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
)
