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())) ...
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

     

     

     

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

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

  • rosscortb's avatar
    rosscortb
    Post Patron
    7 years ago

    • rosscortb's avatar
      rosscortb
      Post Patron
      7 years ago

      Thanks any use?

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        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