Forum Discussion
Slicer not filtering Measure
- 3 years ago
We would need to see your model and how the tables are related to each other, and the DAX in the measures that are unaffected. Post actual text for the DAX, and format it please using DAXFormatter.com - I cannot read that tiny image and cannot debug unformatted DAX like that.
Use this button in the forum post menu to post DAX code: - 3 years ago
If the Week Date in the slicer is coming from the OPS Table, it won't work. That table is on the many side of relationships and other tables filter it, but it filters nothing. You could turn on bi-directional filtering, but that is an extraordinarly bad idea. You need a true date table that filters all of your fact tables, then you add the Week date from the date table, and your model should be set up as a Star Schema.
If you want an overview of a date table, see this blog. Create A Dynamic Date Table In Power Query — ehansalytics You can skip the part about making it dynamic. But without a doubt, you need a date table.You should also get rid of all of those 1:1 relationships and merge those tables in Power Query. A 1:1 relationship is 99.9% of the time 1 table split in two.
Microsoft recommends minimizing use of both Many-to-Many and Bi-Directional Relationships. In other words, unless you are a DAX expert, find another way to remodel your data to conform to a Star Schema and don't use these two features. I avoid them both at all costs.
Microsoft Guidance on Many-To-Many Relationships
Microsoft Guidance on Bi-Directional Relationships
Microsoft Guidance on Importance of Star Schema
We would need to see your model and how the tables are related to each other, and the DAX in the measures that are unaffected. Post actual text for the DAX, and format it please using DAXFormatter.com - I cannot read that tiny image and cannot debug unformatted DAX like that.
Use this button in the forum post menu to post DAX code: