If statement 100% true, and false statement is not showing 0 in cards

[dexter2424]

Hi All,

I need some help in Power BI. 

I would like to build a card view (with Multi-Row Card Visual) where I would like to show the count of true and false values. The problem with it, that right now all of the data is "True" , but in the future maybe it's going to be "False" so I would like to write in cards, that:

True: 12 342

False: 0

But now I only see this:

True 12 342

because there is no false value, so it doesn't appear. 

Is there any way to show the 0 values as well?

Thanks,

Dexter

[jthomson · Accepted solution]

Add +0 to your measure. If whatever you're feeding in isn't currently a measure, make it a measure

[v-alq-msft · Accepted solution]

Hi, @dexter2424 

Based on your description, I created data to reproduce your scenario.

Table:

You may create two measures as below.

True = 
var tab = 
SUMMARIZE(
    ALL('Table'),
    'Table'[ID],
    'Table'[Value],
    "Flag",
    IF(
        'Table'[Value]>0,
        "True",
        "False"
    )
)
return
COUNTX(
    FILTER(
        tab,
        [Flag] = "True"
    ),
    [ID]
)

False = 
var tab = 
SUMMARIZE(
    ALL('Table'),
    'Table'[ID],
    'Table'[Value],
    "Flag",
    IF(
        'Table'[Value]>0,
        "True",
        "False"
    )
)
return
COUNTX(
    FILTER(
        tab,
        [Flag] = "False"
    ),
    [ID]
)+0

Result:

Best Regards

Allan

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

[amitchandak]

Add + 0 to your formula. Or use this option.

[jthomson · Accepted solution]

Add +0 to your measure. If whatever you're feeding in isn't currently a measure, make it a measure