SHow Values a %

[Anonymous]

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

[Anonymous]

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 %.  

[Nathaniel_C]

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