Forum Discussion
Circular Relationship
Hi All,
I have below structure in my Power BI Model
Now I want to use inactive join used between Date Dim and Daily Complaints without it going through active joins.
Userelationship cant be solution as I cant have all measures recreated with USerelationship in Daily Complaints as there are plenty of measures there
Also there would be another Dim Tables need to be added in the above structure which can land up in same above situation.So cant have another set of FAX with userelationship
Cant change the Cross Filter Direction of any other join to Single because it says "The filter direction you selected isn't valid for this relationship"
Please guide, any design change also welcome here please.
Anonymous If you want to change the Cross Filter Direction of any relationship, just lie to your data model and tell it that the relationship is 1 to many or many to 1.
15 Replies
Anonymous If you want to change the Cross Filter Direction of any relationship, just lie to your data model and tell it that the relationship is 1 to many or many to 1.
Greg_Deckler Yes I could lie to model and change the cross filter direction but still cant use the Inactive relationship. I have added another DIM table PRODUCT_INFO_DIM as below ,
and now I wana calculate Daily Complaints Qty as 1 DAX in such way that
1. It should follow DATE_DIM -> Daily Complaints join when I select any DATE_DIM field in Report or
2.It should follow PRODUCT_INFO_DIM -> Daily Complaints join when I select any PRODUCT_INFO_DIM field in Report
similarly i may have few more dimension tables to add here and the previously created DAX should work with new join between New Dim and Daily Complaints.
Please suggest
Anonymous Pretty sure what you are after are Calculation Groups. Calculation groups in Analysis Services tabular models | Microsoft Learn