Forum Discussion
Using IN Operator with List of Values
Hi, I am trying to write a DAX function using IN operator. The problem is, I have the list of values which goes between {} are in another table. So I am trying to bring in those values to use in...
I tried it between two unrelated tables. And able to filter values based on compare date on sales.
All sedlected = CALCULATE(sum(Sales[Sales Amount]),Sales[Sales Date] in ALLSELECTED('Compare Date'[Compare Date]))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
amitchandak I have tried that before posting here. The problem is my table has lot of other values, so I need to apply FILTER before selecting all the values. I am not able to use FILTER function along with ALL. I don't have anything to compare in the target table, I just need to get list of values to pass to the IN condition.