Forum Discussion
Direct Query ALL() and ALLSELECTED() Limitations?
Hello, My DAX formulas containing ALL() and ALLSELECTED() do not seem to be working as advertised within the context of a Direct Query Connection. Query TimeFrame Seconds =
VAR Start_time...
When using Direct Query, filtering is based on your slicers even if you use ALL. This function (and related ones) do still work to remove the filter context within a visual.
See this related thread:
https://community.powerbi.com/t5/Desktop/All-Function-Ignored-When-Using-Power-BI-in-Direct-Query-Mode/td-p/63734
AlexisOlson
Super User
Super UserWhen using Direct Query, filtering is based on your slicers even if you use ALL. This function (and related ones) do still work to remove the filter context within a visual.
See this related thread:
https://community.powerbi.com/t5/Desktop/All-Function-Ignored-When-Using-Power-BI-in-Direct-Query-Mode/td-p/63734