Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If statement on a Boolean type (Measure)

Hey everyone!   I have a column that has a type of TRUE and FALSE (Boolean) and I am trying to make a measure that just outputs all the true values    I have a a column like so;   Time tracked ...
Need Help
Show and Tell
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous add a custom column in your model to get that label and use that on legend

 

Legend = 
IF ( Table[Is Billable], "Billable", "Non-Billable" )

 

Would appreciate if you give Kudos if my solution helped.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Absolute genius!

 

So what if i wanted to display the different amounts on cards? Like 285 hours billable

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous you can create a measure or put visual level filter and select value "Billable"