Jack2of3's avatar
Jack2of3
Icon for Helper II rankHelper II
4 years ago
Status:
Investigating

Direct Query Slicer Search mode appending an alias to table in Select and failing

Only fails in Direct Query when Search is enabled. Works fine in import. Diagnostic: DEFINE VAR __DS0Core = VALUES('TA_ITEM_CATALOG'[ITEM_CODE]) VAR __DS0PrimaryWindowed = TOPN(101, __DS0Core, ...
Reports
v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
4 years ago
Status changed:
New
to
Investigating

Hi,

What does the DAX formula you used to create? Calculated column/table and measure?

If you are using this to create a calculated column/table, I think this is a limitation of the DAX Values() function:

 

https://docs.microsoft.com/en-us/dax/values-function-dax

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Completed Ideas