Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Afternoon,
I have a table visualization where I need some of the totals changing to be a % instead of a sum
The two % fields aren't correct as they are just summing up the data
Any help would be much appreciated
Thank you
Hi @tbwopsm ,
You can use Format column, to show the % by clicking on the "%" icon on the toobar.
You can create below two columns using DAX expressions,
% Answered in 15s = DIVIDE(Table3[Calls Answered],Table3[Calls Offered])
% Answered After 15s = DIVIDE(Table3[Calls Answered in 15s],Table3[Calls Offered])
And Format as Percentage with two decimals,
On required columns Update as don't Summarize,
Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at crm@inogic.com
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Hi, The information I have in the table is correct. It is the Totals at the bottom which is incorrect. Where it is saying 228.24% it should be 58.28% and where it says 171.76%, it should be 41.71%
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |