Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column total not adding to the total sum

Hi, I'm aware this has been asked before, but I was not able to find a solution with the previous quesitons.  Measure that I'm creating is not adding up to the correct total.  My measure looks l...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try like

Usage Cost = CALCULATE(SUM('Table1'[Total Cost (LCY)]),values(Table1[ID]), 'Table2' [Project Type] <> 0)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Still getting the same total..