Forum Discussion

lhookway's avatar
lhookway
Regular Visitor
6 years ago
Solved

conditionally format table value for a total using another value

Hi all,  I need to format the Employed number in this table to show if the number is < 5 that it shows < 5 and not the actual number.   Employer Name                                              Em...
Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago

    Hi lhookway 


    What you could do, is to create a new measure which would create the values you need for example below.

     

    I have assumed that you have a measure already called [Employed]

     

    Less than 5 =
VAR LessThanFive = IF([Employed] < 5, "<5", [Employed])
RETURN
LessThanFive

     

     

     

GilbertQ's avatar
GilbertQ
Super User
6 years ago

Hi lhookway 


What you could do, is to create a new measure which would create the values you need for example below.

 

I have assumed that you have a measure already called [Employed]

 

Less than 5 =
VAR LessThanFive = IF([Employed] < 5, "<5", [Employed])
RETURN
LessThanFive