Linking problem / Need ideas to avoid alias dimension

[JuhoKoskivuo]

Hi,

I have an issue regarding how to link tables to keep certain functionality.

The data model is huge, but attached an illustrarion of part of it that causes currently problems:

- Dim2 is linked with "Single" direction into Fact 1. This is ok.

- Dim1 is linked with "Both" direction into Fact1 because when applying a slicer from Dim2, Dim1 needs to be filtered for certain reports to show correctly

- Dim1 is linked as "Single" into Fact2 

Problem: Since there are certain dimensions in Dim1 that are included in Fact1 but not Fact2 and vice versa, when filtering with Dim2 also Dim1 gets filtered and loses dimensions that should still show in Fact2

Would really appreciate hints and comments how to:

1. Keep the functionality that when filtering Dim2, also dim1 gets filtered -> necessary for reports based on Fact1

2. Dim1 to not get filtered by Dim2 -> necessary for reports based on Fact2

One solution would be to make an alias table of Dim1 that only talks with Fact2, but I try to avoid it since the model is otherwise build very nicely. Other thing is, that next step would be having a report with numbers from Fact1 and Fact2 - alias propably not the solution.

I've been also trying to make a measure with ALL(Dim1), which basically works but returns all rows from Dim1 to reports made of Fact2 - not very user friendly.

[v-jiascu-msft]

Hi @JuhoKoskivuo,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft]

Hi @JuhoKoskivuo,

Could you share your pbix file please? The solutions or workarounds all depend on your data model.

1. Use "Edit interactions". Then "Dim2" could work on selected visuals.

2. Use DAX functions like "ALL", "ALLSELECTED", "ALLEXCEPT".

Best Regards!

Dale