Forum Discussion

pravind96's avatar
pravind96
Frequent Visitor
6 years ago
Solved

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...
Need Help
Show and Tell
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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,

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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.

pravind96's avatar
pravind96
Frequent Visitor
6 years ago

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