cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## How to correct the Blank into 0 in Card Visual.

Hi,
I have set a mesure show zero to the card visual when select a particular Status.
Example, I select status "Healthy" from filter. My other card visual should have change to "0".

Now, when I select a status, the other card visual remain with same value. It doesn't change to 0.
Here's my current measure that I set:
"Healthy 2 = IF(ISBLANK(CALCULATE(COUNT(Table10[Result 2]), Table10[Result 2] = "Healthy")), 0, CALCULATE(COUNT(Table10[Result 2]), Table10[Result 2] = "Healthy"))"

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: How to correct the Blank into 0 in Card Visual.

Hi @pravind96 ,

We can use the following measures to fix it:

Healthy =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Healthy"
) + 0

Infected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Infectet"
) + 0

Precaution =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Precaution"
) + 0

Suspected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Suspected"
) + 0

Add a 'Table10', in the calculate formula.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Highlighted
Super User IV

## Re: How to correct the Blank into 0 in Card Visual.

Try:

Healthy 2 =
VAR __MyVar =
IF(
ISBLANK(
CALCULATE(
COUNT(Table10[Result 2]),
Table10[Result 2] = "Healthy"
)
),
0,
CALCULATE(
COUNT(Table10[Result 2]),
Table10[Result 2] = "Healthy"
)
)
RETURN
IF(ISBLANK(__MyVar),0,__MyVar)

If that doesn't work, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Highlighted
Frequent Visitor

## Re: How to correct the Blank into 0 in Card Visual.

It's still showing the same results as mine. Other card visual doesn't show 0.

Community Support

## Re: How to correct the Blank into 0 in Card Visual.

Hi @pravind96 ,

We can use the following measures to fix it:

Healthy =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Healthy"
) + 0

Infected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Infectet"
) + 0

Precaution =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Precaution"
) + 0

Suspected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Suspected"
) + 0

Add a 'Table10', in the calculate formula.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

## Re: How to correct the Blank into 0 in Card Visual.

Hi, thanks for the answer. It works.

I found this code earlier. It works too.

Healthy 2 = IF(ISBLANK(CALCULATE(COUNT(Table10[Result 2]), Table10[Result 2] = "Healthy")), 0, CALCULATE(COUNT(Table10[Result 2]), Table10[Result 2] = "Healthy"))

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors