Showing zero values?

[rosscortb]

Hello

Any ideas why this is not showing as 0.00% instead of (blank), I tried adding +0 but didn't work.

Absence Rate = CALCULATE(DIVIDE([Total Absence Days1],[Total headcount]*22,BLANK()))

Thanks

Ross

[PattemManohar]

@rosscortb It seems fine with your calculation, could you please post the screenshot as well if possible ?

[rosscortb]

[rosscortb]

Thanks any use?

[v-lili6-msft · Accepted solution]

hi, @rosscortb 

You may try these formula

Absence Rate =
CALCULATE ( DIVIDE ( [Total Absence Days1], [Total headcount] * 22, 0 ) )

or

Absence Rate =
CALCULATE ( DIVIDE ( [Total Absence Days1], [Total headcount] * 22, 0 ) ) +0

or

Absence Rate =
CALCULATE ( DIVIDE ( [Total Absence Days1], [Total headcount] * 22, BLANK () ) ) +0

 If you still have the problem, please share a simple sample pbix file.

Best Regards,

Lin

[rosscortb]

Thanks Lin.

Last two worked. 🙂