Forum Discussion

santiago01's avatar
santiago01
Frequent Visitor
7 years ago
Solved

Calculate Sum based on another column

Hello, I have a table with projects and hours. Each project has a corresponding proposal number.     How can I create a measure that adds all the hours for the corresponsing proposal and sh...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    santiago01 ,

     

    You can create a measure using DAX below:

    SumProjectHours = CALCULATE(SUM('Table'[Hours]), ALLEXCEPT('Table', 'Table'[Project_Number], 'Table'[Proposal Number]))

     

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

santiago01 ,

 

You can create a measure using DAX below:

SumProjectHours = CALCULATE(SUM('Table'[Hours]), ALLEXCEPT('Table', 'Table'[Project_Number], 'Table'[Proposal Number]))

 

Community Support Team _ Jimmy Tao

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