A data model with two tables and two slicers

[raymond]

Hi Guys,

I have yet again an Issue. A now very simple data model with two fact sheets. I want to use slicers and buttons in order to filter the data. The values for the slicer should come from 2 different tables.

This is the model: I know right now it is not correct as the results show on the second image. 

Here you see which tables should be used for the slicers. However, once I put Impressions into one matrix, the values are not correct anymore. Compare it to the seperate tables. 

 

Sample Data to Download:

Click

The big question: how can I achieve it to make it filterable and at the same time maintain these tables. This is a mere simple model, I should be more complex but the issue is always the same. 

[raymond]

I played around a little bit and created a unique key with which it seems to be working. However, does this model, that looks like a loop make sense. Would that be a best practice approach?

Sample File

[v-yuta-msft]

Hi raymond,

Yes, this issue is because you have set both direction, change it with single direction can remove the loop. So your second solution can resolve this issue. 

Regards,

Jimmy Tao

[raymond]

Is it then common practice to solve it like this or are there more elegant ways to do so?

[v-yuta-msft]

Hi raymond,

The issue is because the relationship direction, so change the direction of table relationship is the best way to solve it.

Regards,

Jimmy Tao

[raymond]

Mhh I attempted that as a first step but couldnt achieve the wanted resulted throughout all the wanted visualisation. Either one was working or the other but not the both. I am not sure though if I did it all right. To me it seemed as if this way, setting a unique key for each category, was the only way to achieve the results. 

Can you recommend a good explanation about the workings of the direction of table relationships?