Dimension tables not filtering Fact table correctly, instead displaying all the values

[makcim392]

Hi, 

I have this relationship

For some reason I can´t get persons to filter the sales table. As you can see below it is showing the total of persons, for each product in each of the purchase dates. If I do that with client, it shows the correct values. 
I modified the relationships a bit, because there´s a bridge table (as you can see in the relationships screencap), but that wasn´t helping either. 

Previously, the facts table was linked to the client dimension, client dimension to it´s bridge, and the bridge table to persons dimension. 

I double checked every relationship, messed with crossfiltering options, etc, without any success. 

any help is much appreciated. 

regards!

[sturlaws]

Hi @makcim392, not easy to determine why it is not showing any values based on your description. 

From your Person-table, can you find a couple of values from the column you have used for the relationship with the Monthly Sales-table, and verify that these values exists in the column in the Monthly sales-table used for the relationship?

[makcim392]

yes, I´ve already done that. There are data available for persons in the sales table.

[sturlaws]

That is all I can think of. I can take a look at it if you share the report with me, either here in thread or in PM. Or try to recreate the issue in a sample file and share that