Question about Direct Query

[Anonymous]

Hello guys,

I have two tables:

- One with aggregated data which is Imported.

- One with detailed data which is DirectQuery.

Both connected to some dimensions.

Then I have a Calendar made it with DAX, and another one which is a copy connected with the other so I can compare data.

Measures:

CTR = DIVIDE([Total Clicks];[Total Impressions];0)+0 

(Both Total Clicks and Total Impressions are just simple SUM)

When I use this measure everything is ok, but then I have this other measure:

CTR - Comparison = CALCULATE([CTR];ALL(Calendar);USERELATIONSHIP(Calendar[Date];'Calendar - comparison'[Date]))

And when I use it, it goes DirectQuery. Does that make any sense? I am missing something there?

Thank you.

[v-joesh-msft]

Hi @Anonymous ,

Try changing the direct query mode to import mode to see if it will report an error. It would be helpful to share the screenshots of the error message or partial sample data.

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.