Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 Dat...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      v-gizhi-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi,

       

      I am sorry that i have forgotten attaching the img, please see this:

       

      Best Regards,

      Giotto

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi

         

        I've tried your solution but it didn't work.

        But you gave me one idea and I've change a few things.

        Link to Now Order ID works. Link to Campaign ID works.

         

        The problem I have is that the Order Date from Google Ads table is not linked to Append1. PowerBI doesn't allow me an active relationship.

        I tried both. In Red, a direct connection between tables. In green using a Bridge Table.