Filtre between dimension doesnt work with a single column

[Anonymous]

Greeting community , 

i have connected to a cube (Live connection method ) , my model contain ( 32 dimensiosn and  9 fact ) 

this is a part of my model : 

As you can see the relation between the dimensions and the fact exist , the problem here that i cant build filter between my dimensions without adding another column . and i find it weird . here is an exemple : (first table containt the column Iduser from Dimuser and the second table contain DepartmentCode from DimEntity )  when i filter doesnt nothing happen : 

But if i add the DepartmentCode from DimEntity to the first table , the Filtre works : 

anyone faced such issue ? Thanks in advance 

[ibarrau · Accepted solution]

Hi there. It looks like you need to filter between dimensions. The behaviour is correct. If you add two columns the deparment will filter the fact giving you the users related to the fact table. The only way to make that work is sharing columns in visualizations, otherwise you need to make a small change in the data model.

To keep the model consistency and avoid changing navigations and filter directions you can try measures that will help you filter between dimensions. You have to create a measure in the fact that will return 1 if you are filtering the fact, that way if you have a visualization like the list of users and you want to filter it by another dimension, you can just add a visual level filter with that measure asking if it's 1.

This post explains it step by step:

https://blog.ladataweb.com.ar/post/185907335292/datamodeling-sincronizar-filtros-entre

In case you don't want to read that much you can take this shortcut haha. Add a measure like this:

Filter_Dimension_by_fact = INT ( NOT ISEMPTY ('Fact_Table') )

Add the measure as a visual level filter on the visualization you want to be affected by dimension filtering as equals to 1.

Hope this helps.

Regards,

[Anonymous]

First of all , Thank you so much ! it works  . 

but i still dont undrestand why i had to add the filtre even my model looks Correct . 

thanks for the shortcut measure 😛 

Best regards