Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Need Help - Matrix Table Row Field Not Showing from Inactive Relation - Two Calendar Date Comparison

Currently I have a matrix table which is supposed to compare Lead Sources between two different calendar ranges for lead count. I have two seperate calendar tables with relationships to the main table. The 'Calendar' table has an active relationship and the secondary 'Calendar_Comparison' table has an inactive relationship with the main table ' ls2yrs'. 




All the columns within my matrix table are properly displaying based on two dates. However, I'm having issues with the 'LeadSourceName' rows of the matrix table not showing all values that exist in both date ranges! In my data set the two different date ranges selected will not always have the same lead sources. For example:


'Calendar' Date Range (Active Relationship with main table): Jan 1, 2000 to Jan 5, 2000 contains lead sources:

Lead Source : Lead Count

- A lead : 1

- B lead : 2

- C lead : 1


'Calendar_Comparison' Date Range (Inactive Relationship with main table): Jan 6, 2000 to Jan 10, 2000 contains lead sources:

Lead Source : Lead Count

- A lead : 1

- B lead : 3

- C lead : 1

- D lead : 2


In this example above, the matrix table will seem to only show rows relating to lead sources which are present from the active relationship calendar table. It is missing 'D lead' which is present only on the inactive relationship 'Calendar_Comparison' date range table.


Matrix Table 

Lead Source : Lead Count : Lead Count Comparison

A lead : 1 : 1 

B lead : 2 : 3

C lead : 1 : 1



How should I reconfigure my report so I can get D lead to also show up for my date comparision matrix table?     

Super User
Super User

@SparkDataGuru , check if you are trying this


How to use two Date/Period slicers

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Thank you Amit! Great video series you have going on your channel! You just gained another subscriber 😁


Doing it your way works at the video time 6:26:


By setting the 'Lead Count Comparison' to CALCULATE for 'Lead Count' 'with the FILTER being the maxx and minx reflective of the ALLSELECTED of the 'Calendar Comparsion' table, I was able to return all my lead sources as well as compare between two different date ranges! 


Follow up question: Isolated Secondary Date Table vs Inactive Relationship Secondary Date Table

I do have an additional question: I also watched your previous video  "Power BI Abstract Thesis Episode 18" . At video timing 8:09, you mentioned that your secondary date table (Date2) does not have a relationship with the main table, it is isolated.


I'm quite new to Power BI, I was wondering if I were to establish an inactive relationship for my secondary date table to main table, what impacts would that have when I'm building a comparsion matrix/table? Would this impact my comparison measures in any way (inactive realtionship vs isolated table)? 

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors