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.
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.