Forum Discussion

RPAI2812's avatar
RPAI2812
Icon for Helper I rankHelper 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

     

SteveHailey's avatar
SteveHailey
Icon for Solution Specialist rankSolution Specialist
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