Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Percentage Calculation & Sumumarization

Hello,  I have a table for purchase order data. I created a column with the following calculation to get the '%Spent'. [ % Spent] = DIVIDE('Orders'[Amount Expended], 'Orders'[Overall Limit]) . There...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Calculated column couldn't show dynamic aggregation value like the sum of column 1 divided by the sum of column 2. You see if you create [%Spent] as a calcualted column, it will show you sum/max/ do not sum/ and so on based on the column result. You can try to create a measure to achieve your goal.

    Measure % Spent = DIVIDE(SUM('Orders'[Amount Expended]),SUM( 'Orders'[Overall Limit]))

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

vojtechsima's avatar
vojtechsima
Super User
4 years ago

Hi, Anonymous 
You can use MAX function to take only one value for your Order.

If you want a tailor-made solution, please share a copyable sample dataset. Thank you

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I tried playing around with the MAX function but it didn't resolve the issue.

  • vojtechsima's avatar
    vojtechsima
    Super User
    4 years ago

    Anonymous 
    Please share a sample dataset (copyable).