Display 0 Instead of blank

[TaylorLile]

Hello,

I know this question has been posted before, but I've tried their solutions and they don't work for me. I'm trying to caclulate the number of distinct presription codes per patient by using the following:

Perscriptions = (CALCULATE(DISTINCTCOUNT(Claims[RxCd]),ALLEXCEPT(Claims,Claims[patient_id])) - 1)

This is working perfectly, except the patient IDs that are in other tables and not in the claims table show up as blank and dissapear. Is there a way to dispay as 0, not blank?

I've tried doing an IF statement like below, but it doesn't change anything. I'm not sure why. 

IF(ISBLANK(

(CALCULATE(DISTINCTCOUNT(Claims[RxCd]),ALLEXCEPT(Claims,Claims[patient_id])) - 1)),0,CALCULATE(DISTINCTCOUNT(Claims[RxCd]),ALLEXCEPT(Claims,Claims[patient_id])) - 1)

Thanks for any help you can provide. 

[Anonymous]

Hi,

Please try the formula IF(TableName[ColumnName]<=10,"100","0")

[Anonymous · Accepted solution]

Let's try in this way

Perscriptions =

VAR pr = CALCULATE(DISTINCTCOUNT(Claims[RxCd]),ALLEXCEPT(Claims,Claims[patient_id])) - 1

RETURN IF(pr == BLANK() || pr <= 0, 0, pr)

[VasTg]

@TaylorLile 

Maybe move the calculate into a variable and check the variable as blank.

Post some sample data to better assist you.