Forum Discussion

rawiswarden's avatar
rawiswarden
Helper I
6 years ago
Solved

Calculate Total Excluding Row Contribution

Hello,   If I have a simple table like this, where amount is a measure.  What is the DAX to get the total of column Amount excluding that row?   As you can see, the What If Amount is just the tot...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi rawiswarden 

    try a measure like

    Measure = 
calculate(sum(Table4[Amount]);FILTER(ALL('Table4');Table4[Name]<>SELECTEDVALUE(Table4[Name])))

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Hi rawiswarden 

try a measure like

Measure = 
calculate(sum(Table4[Amount]);FILTER(ALL('Table4');Table4[Name]<>SELECTEDVALUE(Table4[Name])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

rawiswarden's avatar
rawiswarden
Helper I
6 years ago

Awesome!  Selected value is what I needed to know.