Measure help required

[harshadrokade]

I want to create a measure wherein if the value comes in a specific range, I want to show that value in text as either "Low" or "Medium" or "High".

If value is between 0-30, the value on chart should reflect as Low

If value is between 31-70, the value on chart should reflect as Low

If value is between 71-100, the value on chart should reflect as High

Pls help sir..

[SanketBhagwat · Accepted solution]

Hi @harshadrokade .

You can use

measure=IF(table name[column name]<=30,"Low",
                 IF(table name[column name]>70,"High","Medium")).

Regards,

Sanket Bhagwat.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harshadrokade]

Thanks a lot Sanket. Appreciate your help

[Greg_Deckler · Accepted solution]

@harshadrokade, @SanketBhagwat's formula will work but I would recommend using SWITCH(TRUE()...) syntax as it tends to be cleaner. Also, place your most likely cases first as this will optimize performance.

[harshadrokade]

Thanks a lot Greg. Appreciate your help sir.

[SanketBhagwat · Accepted solution]

Hi @harshadrokade .

You can use

measure=IF(table name[column name]<=30,"Low",
                 IF(table name[column name]>70,"High","Medium")).

Regards,

Sanket Bhagwat.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.