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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

planning I don't believe you can combine them like that, you will need a measure like:

Measure = IF([User]="Carlos" && [Type of Document] = "B",1,0)

Filter out the 1's.

planning's avatar
planning
Frequent Visitor
5 years ago

Thanks! The thing is that I can´t choose neither the User nor the Type of Doc columns in the measure. Is there a workaround for this?