One DIM filter another DIM

Question

One DIM can filter another DIM using a 'measure-filter' on the visual showing the dimension values, where the measure-filter is testing for a-measure-on-common-FACT > 0, like shown here: https://www.youtube.com/watch?v=6Nu-1_a31iU

I cant make that happen when I move the DIM values from the visual to the filter pane - can it be done, that is - make one DIM in the filter pane filter another DIM in the filter pane? Regards, Henrik

cnenfrnl · Answer

Sure thing and easy thing by means of expanded table.

anonymous · Answer

GREAT to hear, can you give a little hint?My expectation is, that I dont have to use bidirectional relationships...

pauldbrown · Answer

Sure. Create a measure along the lines of :Filter Dim = COUNTROWS(RELATEDTABLE(Fact Table))Add the measure to the filter pane for the slicers and set the value to greater or equal to 1.
&nbsp;
See this example:
&nbsp;
Filter Slicers = 
COUNTROWS(RELATEDTABLE(FTable))
&nbsp;

&nbsp;

anonymous · Answer

Oh, thank you very much ... but I not have been clear about but issue. I know the solution you explain. But I dont want to use slicers in my report, as I want to use the report space for other visuals. So instead of slicers I use the filter pane. In your example, I want to place the Department and Customer as filters in the filter pane, but I cant get them to filter each other in that scenario. What do you think?