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,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
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,

 

pravind96's avatar
pravind96
Frequent Visitor
6 years ago

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"))