Replace "Blank" with 0 on card visual

[akapoor03]

I have these below measures in card visuals. When there is nothing then is shows BLANK, I need 0 instead of BLANK-

1) 

Current Closed Orders = var test=VALUE(FORMAT(NOW()+((1/24)*10),"D/MM/YYYY"))

Return

CALCULATE (

COUNT( 'Packing Jobs'[JobID] ),

FILTER ( ALLSELECTED('Packing Jobs'), [Job Close Time(Date format)] =test )

)

2) 

Closed in < 48 Hrs = var test=VALUE(FORMAT(NOW()+((1/24)*10),"D/MM/YYYY"))

Return

CALCULATE (

COUNTAX('Packing Jobs',if('Packing Jobs'[Time_Taken(Hrs.)] <= 48, COUNT('Packing Jobs'[JobID]))),

FILTER ( ALLSELECTED('Packing Jobs'), [Job Close Time(Date format)] =test )

)

3)

Current % 48 Hrs = var test=VALUE(FORMAT(NOW()+((1/24)*10),"D/MM/YYYY"))

Return

CALCULATE (

COUNTAX('Packing Jobs',if('Packing Jobs'[Time_Taken(Hrs.)] <= 48, COUNT('Packing Jobs'[JobID]))),

FILTER ( ALLSELECTED('Packing Jobs'), [Job Close Time(Date format)] =test )

)/

CALCULATE (

COUNT( 'Packing Jobs'[JobID] ),

FILTER ( ALLSELECTED('Packing Jobs'), [Job Close Time(Date format)] =test )

)

[vivran22 · Accepted solution]

Hello @akapoor03 ,

You may add +0 at the end of your formula.

This may give you the desired results.

Cheers!

Vivek

[TheoC · Accepted solution]

Hi @akapoor03,

One of the ways I like to get around this is by using an IF ( ISBLANK ( .... ) , 0 , ( .... ) ) or IF ( (....) = 0 , 0 , ....  For example:

IF ( 

CALCULATE (

COUNT( 'Packing Jobs'[JobID] ),

FILTER ( ALLSELECTED('Packing Jobs'), [Job Close Time(Date format)] =test ) ) = 0 , 0 ,

CALCULATE (

COUNT( 'Packing Jobs'[JobID] ),

FILTER ( ALLSELECTED('Packing Jobs'), [Job Close Time(Date format)] =test ) ) )

[TheoC]

@akapoor03 here is a great article from Radacad on this: https://radacad.com/replace-blank-with-zero-in-power-bi-visuals-such-as-card

[akapoor03]

@TheoC Thanks a lot

[vivran22 · Accepted solution]

Hello @akapoor03 ,

You may add +0 at the end of your formula.

This may give you the desired results.

Cheers!

Vivek

[SriLakshmi_46]

Instated of 0 I need to display the "?" mark. Can you assist for this

[TheoC]

@SriLakshmi_46 you can add instead of using IF ( .... = 0 , 0 , .....) you will need to swap the middle 0 with IF ( .... = 0 , "?" , .... ).   However, you can only do this where the column itself is text based and not a Whole Number or Decimal.  Reasonbeing, Text (i.e. "?") is not a numeral and cannot be used in value-based measures, etc.  Hope that makes sense?

Theo 🙂