Forum Discussion

RPAI2812's avatar
RPAI2812
Helper I
4 years ago
Solved

Problem when summing filtered table.

I have two tables that are related by the Flight column. I want to add three new columns to Table 1 with the sum of the percentages each Cost Center has on that specific flight (information that is o...
Need Help
  • SteveHailey's avatar
    SteveHailey
    4 years ago

    Hello RPAI2812. I think you may be overcomplicating this one. I loaded your example tables, and created a relationship as follows:

     

    Then created a simple sum measure and matrix visual as seen below:

    Here's a link to a PBIX in case it's helpful.

    -Steve

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I agree with SteveHailey but if you do need a measure or calculated column for CC1 for some reason, this should work (assuming the tables have a relationship on Flight and the calculated column is on Table 1):

CALCULATE ( SUM ('Table 2'[Percentage] ), 'Table 2'[Cost Center] = "CC1" )