SHow Values a %

Question

Hello all.&nbsp; Relatively easy one for you all.&nbsp; 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.&nbsp; I want to be able to rollup the combine % by week for visualizations and also break down by category as needed.&nbsp; 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.&nbsp;&nbsp;&nbsp;Thanks all&nbsp;WeekCategoryCallsUnanswered&nbsp;1Credit1502583%1Debit1251092%2Credit1755&nbsp;2Debit10010&nbsp;

nathaniel_c · Answer

Hi&nbsp;Anonymous&nbsp;,If I understood correctly :

Percentage = 1- DIVIDE(MAX('Table'[Unanswered]),MAX('Table'[Calls]))
&nbsp;
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

anonymous · Answer

Thanks for reply.&nbsp; I am not looking for the MAX.&nbsp; I should have explained better.&nbsp; 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 %.&nbsp;&nbsp;

Forum Discussion

Related content

Show Latest Value & Last N Values

Show only selected Company value

Show Maximum value?

show values for all

Map not showing any values