topic Re: Measure to Sum all values by another value and ignore all filters in DAX Commands and Tips

Measure to Sum all values by another value and ignore all filters

dfsadvantage — Tue, 05 May 2020 18:35:28 GMT

Looking for assitance in aggregating vales by team and populate that aggregated value for each row where team = that players team.

I have been trying to create measure as follows:

Re: Measure to Sum all values by another value and ignore all filters

camargos88 — Tue, 05 May 2020 18:38:26 GMT

Hi dfsadvantage ,

Try something like:

CALCULATE(SUM(RuAtt); ALLEXCEPT(Table, Team, Opp))

Did I answer your question? Mark my post as a solution!
Ricardo

Re: Measure to Sum all values by another value and ignore all filters

dfsadvantage — Tue, 05 May 2020 22:15:25 GMT

Didnt work for me, showed multiple rows of the same player...Here is a better description of what I am trying to do:

1)Calculate the Total RuAtt for each Team by summing the RuAtt for each player on that team.

2)Display the Total RuAtt for each player on the corresponding team/

Re: Measure to Sum all values by another value and ignore all filters

winsterpop — Wed, 06 May 2020 00:59:40 GMT

The earlier proposed solution was close.

The duplication probably happened if they faced the same team more than once in the season.

You need a calculated column:

TeamRuAtt = CALCULATE(SUM(RuAtt); ALLEXCEPT(Table, Team, Week))

Re: Measure to Sum all values by another value and ignore all filters

Anonymous — Wed, 06 May 2020 01:14:38 GMT

// If the model is correct, then such a measure is easy: [RuAtt for Team] = CALCULATE( [RuAtt], // this should be measure VALUES( Teams[Team] ), ALL( Teams ) ) // But if your model is incorrect... well, // I can't help you, I'm afraid.

A correct model is one that follows the principles of dimensional design called "star-schema."

Best

Re: Measure to Sum all values by another value and ignore all filters

dfsadvantage — Wed, 06 May 2020 13:53:44 GMT

Thank you - Calculated Column was the solution. I appreciate your help..!

winsterpop