Forum Discussion
Waterfall chart based on Two tables
Yes, you have 2 options either you can follow the below link and use the DAX USERELATIONSHIP and use an in-active relationship.
https://www.sqlbi.com/articles/using-userelationship-in-dax/
Or create a separate table with unique ids from both the tables as i mentioned previously.
For the optimization use the Filtering direction to a single side instead of both sides.
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
Regards,
Nimai Ahluwalia
Hello Junaid11
The problem you are facing is due to the relationship issue as there is no connection in the model between the ID of those 2 tables as the connection is made only from the date table.
I would not recommend the M*M as to eliminate that you can create a separate table with unique ids from both the tables.
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
Regards,
Nimai Ahluwalia
Hello NimaiAhluwalia ,
Yes I know that but I already have realtionship with date table to which I have make relationship of all the tables. We cannot have active relationship one for date and one for ID column I guess. Is there any other solution that we can keep Date relationship among both the table as well as get the ID based waterfall chart?
Yes, you have 2 options either you can follow the below link and use the DAX USERELATIONSHIP and use an in-active relationship.
https://www.sqlbi.com/articles/using-userelationship-in-dax/
Or create a separate table with unique ids from both the tables as i mentioned previously.
For the optimization use the Filtering direction to a single side instead of both sides.
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
Regards,
Nimai Ahluwalia
Hello NimaiAhluwalia ,
I have managed to add a Bridge Table but its value is repeating in water fall chart once for planned and once for actual
