% Not calculating blank as zero

[BJGRUNDY]

I am trying to show on a matrix the percentage of jobs complete vs the number of jobs complete but the count of does not diplay 0. The count is 

_Count of PVA PASS = CALCULATE(COUNTROWS('dba Job'),'dba Job'[PVA]="Pass")

If I add +0 it then displays all the blanks a 0 and ignors the filters and even then the % does not calculate the 0

[v-binbinyu-msft · Accepted solution]

Hi @BJGRUNDY ,

Please try to use IF() function to determine if the value is blank, when blank show zero.

Please try below dax formula:

_Count of PVA PASS Adjust =
IF ( ISBLANK ( [_Count of PVA PASS] ), 0, [_Count of PVA PASS] )

_KPI% Adjust =
IF ( ISBLANK ( [_Count of PVA PASS] ), 0, [_KPI%] )

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BJGRUNDY]

This give me the same result that the ,0 option does and then ignores the filters. 

How can I get round this?

[parry2k]

@BJGRUNDY what is your ask, you want KPI % to show Zero?

[BJGRUNDY]

The count and KPI to show zero