Top N filter on visual not working on direct query

[Mark91]

Hi everyone,
i was trying to add a top n filter on a table visual in pbi desktop.

And after a lot of test i was not able to compete this simple task, always not showing result.
After i change from direct query to import it start working.
I analized the query and the problem is on this step:

i also try to change the keepfilters with a in operators and still doesn't work.

__SQDS0BodyLimited contains same rows on direct query and import.

what am I not understanding here?


Thanks in advance 
Marco

[v-cazheng-msft]

Hi @Mark91 ,

KEEPFILTERS function is not supported for use in DirectQuery mode when used in calculated columns or row-level security rules.

KEEPFILTERS function (DAX) - DAX | Microsoft Docs

For how to modify your dax formula to fulfill your needs in DirectQuery mode, I would suggest you post your DAX problem in DAX&Commands Tips forum where you could promptly get the help from the DAX experts in the community.

Here is the link of DAX&Commands Tips forum: DAX Commands and Tips - Microsoft Power BI Community

Best Regards,

Community Support Team _ Caiyun