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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Frequent Visitor

Cant create relationship between Date and Calender[Date] .

now i have multiple tables CFS_Import , CFS_Export and CL now i have one more table name List , so i have created relationship between These three tables and the List table , now i when i create a new table named Calendar which contains only Date column , i want to link all the three table Date column with this column , so that when i drag this Calendar[Date] in any slicer it can act as a unified date slicer or when i drag it to x-axis of any line chart and add revenues of different table it will work 'fine , but i am only able to make relationship between one of the table and the rest two table's relationship turns inactive and when i try to turn it active it gives error for ambiguity.

Super User
Super User

Hi @Samarth-Borade only one active relationship in Power BI guarantee filter propagination between tables. To leverage inactive relationship between one calendar / date table, beside active one, you should use DAX  function USEREATIONSHIP. On link below you can find example how to use it in measure. Hope this help. 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors