Show 0 instead of blank

[Jhadur]

I need this card to show a 0 instead of a blank when the green piece of the pie chart is selected.

The card is set up as follows.

     

               

The overall status column has this data. 30 = Red - 20= Amber - 10 = Green

[anmolmalviya05]

Hi @Jhadur, Hope you are doing good!

You can do it by simply creating a measure to calculate count of overall status.
Please use the below measure:

Count of overall status = Count('Projects'[Overall Status])+0
Add this measure in your card and it will show 0 in place of blank

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

[Anonymous]

Hi @Jhadur ,

Have you solved your problem yet? If so, you can mark the correct answer as solution.

Best Regards,

Xianda Tang

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

[Anonymous]

Hi @Jhadur ,

Thank you for @Greg_Deckler answer , and I have other suggestions for you:

Below is my table:

The following DAX might work for you:

Measure = IF(SELECTEDVALUE('Table'[Color]) = "Green" , 0 , BLANK())

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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

[Greg_Deckler]

@Jhadur Not sure what implicit aggregation you are using, count, average, ? But, in any case, create a measure to duplicate that and +0

[Jhadur]

@Greg_Deckler 

Thanks Greg. I am doing a count of the Overall Status shown above. I am new to Power BI. How would I write the meaure to count all of the overall status but only show 0 if the overall status is Green (10)?