Forum Discussion

IoanCosmin's avatar
IoanCosmin
Helper III
6 years ago

Direct Query and Summarize workaround

I am having a hard time finding a way to summarize sevaral direct query tables based on some measures. What's really gets me is that, if I create the summarized table (either with SUMMARIZE() or SUMM...
Need Help
Tutorial Requests
IoanCosmin's avatar
IoanCosmin
Helper III
6 years ago

Hello Zoe,

 

Thank you very much for taking the time to test it for me. I am running March 2020 version and the built in SQL Server connector. The report that I am speaking about is recreated. Are you sure it still works after you close the file and try to open it again? Not sure what else to try. Since SUMMARIZE is not compatible with direct query, I think that's what is causing the problem. https://docs.microsoft.com/en-us/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=asallproducts-allversions&viewFallbackFrom=sql-server-ver15 

 

Not sure what else to try. What would you suggest?

 

Thank you,

C

rivo201's avatar
rivo201
Helper I
4 years ago

Hello! 
I had same issue where SUMMARIZE was not possible to use and for me worked "CROSSJOIN"

SUMMARIZE(
  FILTER(
     CROSSJOIN(
       {DIRECT_QUERY_TABLE} , {OHTER_REQUIRED_TABLES}
     )  
     , {Create relations between Crossjoined tables}
   )
  , {Do calculations}
)