Forum Discussion

icdns's avatar
icdns
Post Patron
5 years ago
Solved

Calculate Percentage

Hello, 

 

I want to calculate and find what is the percentage of the Paperless Bills among the Non Paperless Bills

I have a 2 measures that counts the paperless and non paperless. What can be my formula? 

 

Thank you

  • you can try by creating a measure and format it as Percent.

    _Percent =
    
    FORMAT(
    DIVIDE ([counts of paperless],[count of non paperless],BLANK()) ,"Percent")

     

1 Reply

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion

    you can try by creating a measure and format it as Percent.

    _Percent =
    
    FORMAT(
    DIVIDE ([counts of paperless],[count of non paperless],BLANK()) ,"Percent")