countrow of count value

[reynold522]

We have 10 IoT devices which upload voltage to the cloud continously.

we create a measure to count the voltage if voltage <13 V

if we put this measure (not a column in table) and IoT Number in visulization table in power BI

the value will be summarized in table visulization like following:

IoT ID	Count (Voltage <13V)
1	150
2	130
3	108
4	95
5	92
6	22
7	32
8	56
9	75
10	32

Now I would like to 

1. count IoT devices which has measure: "count (Voltage<13V)" higher than 100, in this case will be 3

2. output maximum value of measure: "count (Voltage<13V)" among all IoT devices,in this case will be 150

Thanks in advance

[tamerj1]

Hi @reynold522 
Please use

=
SUMX ( VALUES ( 'Table'[Lot Id] ), IF ( [Count (Voltage <13V)] > 100, 1 ) )

=
MAXX ( VALUES ( 'Table'[Lot Id] ), [Count (Voltage <13V)] )

[reynold522]

Hi Tamerj1

thanks

it is not working as  count (Voltage<13V) is not a exist column, it is a result of following measure

Voltage<13V =

Calculate(

COUNT(table1[VOLTAGE]), table,[VOLTAGE]<=11.8))

how Can I integrate this measure into your formula. 

Thanks in advance

[tamerj1 · Accepted solution]

@reynold522 
Exactly. Just use the measure in the code 

=
SUMX ( VALUES ( 'Table'[Lot Id] ), IF ( [Voltage <13V] > 100, 1 ) )

=
MAXX ( VALUES ( 'Table'[Lot Id] ), [Voltage <13V] )