Identifier low and higher values

Hi Anonymous 

Given the assessment is happening at the row level, a calculated column is appropriate for this. However, if you want to change the context, then:

1. Create a Measure that sums the amount column

Amount = SUM ( 'Table'[Precio $ / KV] )

2. Create a second Measure such as:

Measure = 

SWITCH ( 
     TRUE () , 
         [Amount] < 500 , "NOT ELIGIBLE" ,
         [Amount] >= 500 , "YES ELIGIBLE" ,
         BLANK() 
       )

If you wanted to only have one measure, you can adjust it to the following:

Measure = 

SWITCH ( 
     TRUE () , 
         SUM ( 'Table'[Precio $ / KV] ) < 500 , "NOT ELIGIBLE" ,
         SUM ( 'Table'[Precio $ / KV] ) >= 500 , "YES ELIGIBLE" ,
         BLANK() 
       )

Hope this helps!

Theo