Two-Condition Filter

[planning]

Hi,

I have a talbe like below:

User        Type of Document       USD

Carlos           A                             10
Carlos           B                             20

Roberto        A                             30

Roberto        B                             40

I want to exclude the lines where "Carlos" and "B" are together (in this case the USD 10 line). Is it possible to use a two-conditions filter in the filter pane in order to avoid using DAX, new columns, etc.?

Please help. Thanks!

[amitchandak]

@planning , You can have measure like

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

[planning]

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?

[Greg_Deckler]

@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]

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?

[planning]

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?

[planning]

* In this case the USD 20 line (sorry)