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
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:

     

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

      Hi, DaHolla 

       

      I test it and it's different with you. Is your DQ data source from powerbi datasets? When you write measure, the fields in the date table should not appear automatically,right? 

       

      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

        Hi v-janeyg-msft,

        The fields do appear automatically from the date table, with both the Sales_Agg and Sales_Detail tables. Another reason why I'm so confused the measures behave differently.