Forum Discussion
Solved
Except with dynamic filter is not working
i am trying to get all students from my table 1 that do not exist in table 2 using EXCEPT function. I was able to get it work when filters were hardcoded but as soon as i added dynamic filter, result...
problem has been resolved. second filter was applied for both which is why result was blank. thanks for trying
parry2k
Super User
Super Usersunnysrujan also it is very hard to provide a solution without knowing how these tables are related to each other. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
selectTrackingTerm is single selection and yes it is showing value, also i tested the same measure by providing hardcoded values and it gave me accurate results, which is why this is confusing