Forum Discussion
A single report with pages using different relational models
I have a report that needs as the title states; one page using a different relational diagram to the rest. The diagram for this page just needs to delete a couple relationships with the datetable as it is throwing the data off and breaking visuals within this specific page. Is there a way to accomplish this?
This page has to be presented in the same report. Thanks
I do not know if I correctly understood the problem as your description is very brief, but if I understood correctly you want one page with visuals using a relationship with the Date table, and another page with visuals that do not use the relationship. If it is the case, I would create by default the relationship between the fact and the date table in the model as inactive and activate it (or not) the relationship using USERELATIONSHIP in DAX
If it answers your need, please mark my reply as the solution. Thanks!
2 Replies
- Alex87
Solution Sage
I do not know if I correctly understood the problem as your description is very brief, but if I understood correctly you want one page with visuals using a relationship with the Date table, and another page with visuals that do not use the relationship. If it is the case, I would create by default the relationship between the fact and the date table in the model as inactive and activate it (or not) the relationship using USERELATIONSHIP in DAX
If it answers your need, please mark my reply as the solution. Thanks!
Thank you. It worked!
