Forum Discussion
Identifier low and higher values
Good afternoon, I seek to identify the values greater than 500 and less than 500, that when the values are greater than 500 tell me that it is not "NOT ELIGIBLE" and if they are less than 500 "YE...
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
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