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.
Hello all. Relatively easy one for you all. The below chart being the example of my data, I am looking to create the % values in the right most column via a Dax formula. I want to be able to rollup the combine % by week for visualizations and also break down by category as needed. I created a simple 1-(25/150) in the query, but it does not allow for a true representation of the % in the graph with using the average.
Thanks all
Week | Category | Calls | Unanswered | |
1 | Credit | 150 | 25 | 83% |
1 | Debit | 125 | 10 | 92% |
2 | Credit | 175 | 5 | |
2 | Debit | 100 | 10 |
Thanks for reply. I am not looking for the MAX. I should have explained better. The solutions I would be looking to visualize in a chart would be showing the Debit % as a rollup over the two weeks or being able look at the Credit and Debit Service % for that week combined in a single %.
Hi @Anonymous ,
If I understood correctly :
Percentage = 1- DIVIDE(MAX('Table'[Unanswered]),MAX('Table'[Calls]))
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |