Forum Discussion

makcim392's avatar
makcim392
Advocate I
6 years ago

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

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!

Need Help

3 Replies

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    6 years ago

    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's avatar
      makcim392
      Advocate I
      6 years ago

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

      • sturlaws's avatar
        sturlaws
        Resident Rockstar
        6 years ago

        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