Forum Discussion
Metric not filtering by date
Hi All!
I've loaded 3 tables and joined them. But I have the problem that one metric doesn't get filtered by date. The Cost metric.
I don't know what I'm doing wrong.
This table is using Order Date from OMS table and Cost from Google Ads table.
The 3 tables are
- OMS
- Google Analytics
- Google Ads
And the relationships are
OMS with Google Analytics
Order Date <-> Order Date
Order ID <-> Order ID
Google Analytics with Google Ads
Google Ads Campaign ID <-> Google Ads Campaign ID
OMS with Google Ads
Order Date <-> Order Date
11 Replies
- Greg_Deckler
Community Champion
Um, that's an ugly data model, no offense. The issue is likely the two bidirectional many-to-many relationships you have between those two tables. The direct many-to-many is inactive. You could try it using USERELATIONSHIP but I would strongly recommend refactoring your data model and getting rid of many-to-many relationships by putting bridge tables between them.
Thanks!
I'm kind of you new with powerBI and I've never done more than one relationship between tables.
I've looked on the internet about the Bridge Tables and under PowerBI documentation, it says this used to be a workaround but not needed anymore. See your self https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships
- v-gizhi-msft
Community Support
Hi,
I am sorry that i have forgotten attaching the img, please see this:
Best Regards,
Giotto
- v-gizhi-msft
Hi,
Please try to change the relationship marked by red circle to inactive and the relationship marked by blue circle to active.
Hope this helps.
Best Regards,
Giotto
