Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
7 years ago
Solved

Showing zero values?

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
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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