cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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

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:

1 ACCEPTED SOLUTION
Regular Visitor

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))

5 REPLIES 5
Community Champion

Try something like:

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

Ricardo

Proud to be a Super User!

Frequent Visitor

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/

Anonymous
Not applicable
``````// 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,

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

Best

D

Regular Visitor

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))

Frequent Visitor

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

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors