Solved: Calculate Percentage

icdns · ‎01-24-2021

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

FarhanAhmed · ‎01-24-2021

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

_Percent =

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

FarhanAhmed · ‎01-24-2021

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

_Percent =

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

Calculate Percentage