Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi @engyin2,
Add a measure with the following syntax:
Average Coverage = DIVIDE ( SUM(Table[Actuals]), SUM(Table[SFDC]))
Then format as percentage.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Make sure it is a measure, not calculated column.
Hi @engyin2,
Add a measure with the following syntax:
Average Coverage = DIVIDE ( SUM(Table[Actuals]), SUM(Table[SFDC]))
Then format as percentage.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi MFelix,
Thanks for your advise.
I have changed the formula according to your suggestion and change the value of the coverage to 'average'. However, the % for all three month and total is the same, all showing 128.89%.
How to make the BI understand, the result is Jan (156.89 divided by 77.7M = 204%) and Feb (95.11M divided by 28.99M=328%) and etc. Thanks
Make sure it is a measure, not calculated column.
Thanks! It works well now ! \O/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |