Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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
Solved! Go to Solution.
you can try by creating a measure and format it as Percent.
_Percent =
FORMAT(
DIVIDE ([counts of paperless],[count of non paperless],BLANK()) ,"Percent")
Proud to be a Super User!
you can try by creating a measure and format it as Percent.
_Percent =
FORMAT(
DIVIDE ([counts of paperless],[count of non paperless],BLANK()) ,"Percent")
Proud to be a Super User!
User | Count |
---|---|
84 | |
70 | |
68 | |
58 | |
51 |
User | Count |
---|---|
44 | |
41 | |
34 | |
34 | |
30 |