Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

SUMMARIZE link with a second date table with and inactive relationship

Hi all


For the final result of my report, I need to create 2 tables using SUMMARIZE 


My fact table (TblSales) is linked with a date tabel (using the DateID). The date table is also linked with a second date table using an inactive 1-to-1 relationship. The reason why is that I need to compare two adjustable periodes (FYI : it is a sales report in which I need to compare the average prices of two adjustable periode) 


My first table is correct 

TblTemp1 = SUMMARIZE ('TblSales' 'TblSales'[CustomerNo], 'TblSales'[MaterialNo])


The second table (I will use this is a measure as a variant) that I need to created needs to ignore the filtercontect of the first date table, and take into account the filter context of the second date table. 


Can someone help me out on this one? 

I assume it is with function USERELATIONSHIP, but I do not manage to get it right 








The first tabel is based on a 


Why do you need to use Summarize?  It has its place, but is often used incorrectly in place of using visuals such as a Matrix to generate the required outcome. 

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.