Forum Discussion

PerAsperaAdAstr's avatar
PerAsperaAdAstr
Helper I
6 years ago
Solved

How do i relate summary table (created by Summarize)

Hi all,   Not sure if this is a simple problem because I couldnt find anything online. How do I add a relationship between Summary table into the rest of the Data Model. I created "Ranking Table" f...
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi PerAsperaAdAstr ,

     

    For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationship between table 'RankingTable' and 'DimPlatform', active the relationship between table  'RankingTable' and 'DimDate', and change the Cross filter direction of all the relationships above from Single to Both , which will take these tables treated as a single table. Then when you make some changes or interact in someone table, the other table objects will return corresponding matched result.  See more:Create and manage relationships in Power BI Desktop .

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi PerAsperaAdAstr ,

 

For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationship between table 'RankingTable' and 'DimPlatform', active the relationship between table  'RankingTable' and 'DimDate', and change the Cross filter direction of all the relationships above from Single to Both , which will take these tables treated as a single table. Then when you make some changes or interact in someone table, the other table objects will return corresponding matched result.  See more:Create and manage relationships in Power BI Desktop .

 

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.