Show non-existent Boolean value on visual

[Anonymous]

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 is either TRUE or FALSE. If an item has been correctly handled it shows TRUE.

Now at the very start of the project, zero items have been correctly handled meaning all values are FALSE. However, I want the card to depict that currently there are 0 TRUE options. Due to the fact TRUE is currently not existent in the list I can not filter the TRUE options. Is there a way to display on the Card that 0 options are TRUE without having to make an extra measure to count the TRUE values?

[Syndicate_Admin]

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]

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 · Accepted solution]

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.