Forum Discussion

TonicQuake's avatar
TonicQuake
Regular Visitor
5 years ago
Solved

Calculations with table relationships.

Morning All, 

 

I've added in a few tables and created the relationships between them, Image Below. 

I'm trying to create a calculation that SUM's Commission from the Policy Commission table, based on Filters from the Team and Introducer tables. 

This is what I've done currently but it doesnt return any values I have also tried wrapping the Team filter in the FILTER expression but getting the same result zero values.

 

CALCULATE(
            SUM('PolicyCommission'[Commission])
                ,'Team'[Teams] IN {"T-A", "T-B", "T-C"}
                ,'Introducer'[Introducers]="Company A"
        )

 

Any help would be greatly appreciated. 

 

Thank. 

 

  • The data model looks mostly ok, apart from the bidirectional 1:1 relationships. Are you sure you cannot combine the three involved tables into one?

2 Replies

  • The data model looks mostly ok, apart from the bidirectional 1:1 relationships. Are you sure you cannot combine the three involved tables into one?

    • TonicQuake's avatar
      TonicQuake
      Regular Visitor

      Thank you for replying. 

       

      I've combined the three tables into one and it is now working.