Forum Discussion

DaHolla's avatar
DaHolla
Frequent Visitor
5 years ago

Dual Mode Inconsistency

I am writing a measure that uses a sales table (direct query) and our date (dual) table. The sales table has some aggregate (import) tables as well. The measures uses SUMMARIZE, and when I write the...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, DaHolla 

 

Is there a relationship between 'Sales_Detail' and 'DATE'? We need more information to judge.

 

Best Regards,

Community Support Team _ Janey

 

  • DaHolla's avatar
    DaHolla
    Frequent Visitor
    5 years ago

    Sorry, I thought I provided the join info in my post!
    Sales_Detail is joined to DATE on a datekey, many to one cardinality, single cross filter direction, relationship is active. The join to Sales_Agg is identical.

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      Hi, DaHolla 

       

      The direction of the relationship is very important. Generally speaking, the relationship between the calendar table and the main table should be one-to-many, not many-to-one.

       

       

      Did I answer your question ? Please mark my reply as solution. Thank you very much.
      If not, please feel free to ask me.


      Best Regards,

      Community Support Team _ Janey

       

      • DaHolla's avatar
        DaHolla
        Frequent Visitor
        5 years ago

        v-janeyg-msft 
        That appears to be how my tables are setup: