Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SHow Values a %

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

 

WeekCategoryCallsUnanswered 
1Credit1502583%
1Debit1251092%
2Credit1755 
2Debit10010 

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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