Forum Discussion

ssutton's avatar
ssutton
Frequent Visitor
6 years ago
Solved

CREATE CALULCATIONS ON VALUES FROM SELECT ROWS

I need to create a measure that DIVIDES the SUM of select rows in column A by the SUM of select rows in column B.   Amount of Overhead Cost + Amount of PTO = TOTAL COST The TOTAL COST will be used...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try new measures like


    cost = calculate(sum(table[Amount]),table[Column A] in{"Overhead Cost","PTO"})
    revenue = calculate(sum(table[Amount]),table[Column A] ="Revenue")

    Ratio =divide([cost],[revenue])

amitchandak's avatar
amitchandak
Super User
6 years ago

Try new measures like


cost = calculate(sum(table[Amount]),table[Column A] in{"Overhead Cost","PTO"})
revenue = calculate(sum(table[Amount]),table[Column A] ="Revenue")

Ratio =divide([cost],[revenue])

  • ssutton's avatar
    ssutton
    Frequent Visitor
    6 years ago

    Thank you for your quick response.  This is very close, but the cost formula doesn't account for the "PTO" value being located in a different column,

     

    cost = calculate(sum(table[Amount]),table[Column A] in{"Overhead Cost","PTO"})

     sum table amount Column A + sum table amount Column B