Forum Discussion

BruCe05's avatar
BruCe05
New Member
4 years ago
Solved

Help calculating percentages for a graph

Hello everyone,    If you could kindly help me figure our how to fix my problem, I would greatly appreaciate it!   What I'm trying to do is this: I have 4 columns Date, Calls, Sales, %. The % c...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi BruCe05 

     

    Please create a measure instead of a calculated column. This is more recommendable. 

     

    Percent = DIVIDE(SUM('Table'[sales]),SUM('Table'[calls]))

     

     

    If you want to have it in a calculated column, try below DAX

    % = DIVIDE(CALCULATE(SUM('Table'[sales]),ALLEXCEPT('Table','Table'[Date])),CALCULATE(SUM('Table'[calls]),ALLEXCEPT('Table','Table'[Date])))

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

BruCe05's avatar
BruCe05
New Member
4 years ago

Thank you v-jingzhang this solution did the trick!

Best regards!