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

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.