Forum Discussion

whenriques's avatar
whenriques
Helper I
4 years ago
Solved

Create Relationship to Add Field to Matrix Report

Any chance you can, please, help me create a relationship to add the '"Total Revenue" to the matrix report below:   I have the relationship of the tables using "Period." See below    ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi whenriques ,

     

    Please check if this is what you want.

     

    Total Overrun =
CALCULATE (
    SUM ( 'Overrun Data'[amount] ),
    USERELATIONSHIP ( TopRankingQuery[OrgName], 'Overrun Data'[Organization] ),
    FILTER ( 'Overrun Data', 'Overrun Data'[OFRmapping] IN { "overrun" } )
)

     

    The basic logic is to create an inactive relationship and use USERELATIONSHIP() function to active the relationship while doing the calculation.

     

    Best Regards,

    Jay

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi whenriques ,

 

Please check if this is what you want.

 

Total Overrun =
CALCULATE (
    SUM ( 'Overrun Data'[amount] ),
    USERELATIONSHIP ( TopRankingQuery[OrgName], 'Overrun Data'[Organization] ),
    FILTER ( 'Overrun Data', 'Overrun Data'[OFRmapping] IN { "overrun" } )
)

 

The basic logic is to create an inactive relationship and use USERELATIONSHIP() function to active the relationship while doing the calculation.

 

Best Regards,

Jay

 

whenriques's avatar
whenriques
Helper I
4 years ago

Hi Anonymous,

You are 'da man!!!! I have been trying to solve this question for almost a week by watching tons of videos, spending hours with this group, and working with my model for hours.... 🙂

 

Thank you so very much for your time and for helping me solve this Power BI question! I am grateful for your help and assistance and would love to buy you a cup of your favorite beverage in case you come to the Phoenix, AZ area!!

 

Cheers and thanks again,

 

Willer