Forum Discussion

icdns's avatar
icdns
Icon for Post Patron rankPost 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 f...
  • FarhanAhmed's avatar
    5 years ago

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

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