Forum Discussion

planning's avatar
planning
Frequent Visitor
5 years ago

Two-Condition Filter

Hi,   I have a talbe like below:   User        Type of Document       USD Carlos           A                             10 Carlos           B                             20 Roberto        A  ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

planning , You can have measure like

calculate(sum(Table[USD]), filter(Table, Table[User] = "Carlos" && Table[Type of Document] ="B"))

planning's avatar
planning
Frequent Visitor
5 years ago

Thanks! The only thing is that in this way I'm including that information when I want to exclude it. How can I filter it out instead of in?