Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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.
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.
https://learn.microsoft.com/en-us/dax/userelationship-function-dax
Proud to be a Super User!
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 15 | |
| 14 | |
| 9 | |
| 8 | |
| 7 |