Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Doesn't Works

My filter does not show the dataset options, even with the dimension table correctly classified. What is stranger is that the options appear from a date, and others do not. The fields selected in th...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    This can be a number of things.

    • You have blank values it seems in your DIM table. That is never good. You shouldn't have data in your FACT table not in your DIM table unless you intend to, and then you will be using different measures for calculating values, and you cannot use filters/slicers efficiently since those don't exist in the DIM table.
    • Could be spelling differences, or spaces. Is it "Shopping" in one table and "Shopping     " in your other table?
    • I am not clear on how that bi-directional many-to-many is affecting the model for these particluar fields.

     

    There could be other issues too. Without the PBIX, just tossing out things for you to look at.

edhans's avatar
edhans
Community Champion
6 years ago

This can be a number of things.

  • You have blank values it seems in your DIM table. That is never good. You shouldn't have data in your FACT table not in your DIM table unless you intend to, and then you will be using different measures for calculating values, and you cannot use filters/slicers efficiently since those don't exist in the DIM table.
  • Could be spelling differences, or spaces. Is it "Shopping" in one table and "Shopping     " in your other table?
  • I am not clear on how that bi-directional many-to-many is affecting the model for these particluar fields.

 

There could be other issues too. Without the PBIX, just tossing out things for you to look at.

Anonymous's avatar
Anonymous
Not applicable
6 years ago


It worked, and it was for something related to point three of what you mentioned.

I have no idea why, but the fact that there is a many-to-many relationship between D_Store and the second fact table was messing up the relationship with the first fact table as well. When I canceled the many-to-many relationship with the second fact table, everything worked normally.

 

Thank you, bro!

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    Glad you got it sorted out Anonymous.

    I'm pretty good with Power BI, but even I will avoid Many-to-Many relationships wherever possible. It is different beast and can have odd effects on the model. You need to fully understand what it is doing. I'm not to that chapter in The Definitive Guide for DAX yet. ğŸ˜€