Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show non-existent Boolean value on visual

For a visual I have a Card which is supposed to show the number of items that have been correctly handled.   To evaluate if an item is correctly handled an IF statement is written and the outcome i...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    In this case, since there is no "true" field in the table, you must create additional measure and construct a context to count the "true" field.

     


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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

if the measure returns BLANK you can instead have it return ZERO (0).

you just have to add + 0 to the end of the formula

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Currently it either returns either TRUE or FALSE, because an item is either correctly handled or it is not. There is no inbetween. So currently it only returns FALSE while I want to show the number of times TRUE is returned (0).

 

Edit: Spelling

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    In this case, since there is no "true" field in the table, you must create additional measure and construct a context to count the "true" field.

     


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