Two-Condition Filter

Question

Hi,&nbsp;I have a talbe like below:&nbsp;User&nbsp; &nbsp; &nbsp; &nbsp; Type of Document&nbsp; &nbsp; &nbsp; &nbsp;USDCarlos&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Carlos&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Roberto&nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30Roberto&nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp;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.?&nbsp;Please help. Thanks!

planning · Answer

* In this case the USD 20 line (sorry)

greg_deckler · Answer

planning&nbsp;I don't believe you can combine them like that, you will need a measure like:
Measure = IF([User]="Carlos" &amp;&amp; [Type of Document] = "B",1,0)
Filter out the 1's.

amitchandak · Answer

planning , You can have measure like
calculate(sum(Table[USD]), filter(Table, Table[User] = "Carlos" &amp;&amp; Table[Type of Document] ="B"))

planning · Answer

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 · Answer

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?

Forum Discussion

Two-Condition Filter

6 Replies

Related content

Filtering by two conditions

Using two filters with a conditional

Page filter with two conditions

Conditional Format Based on Two Columns

Filtering relative date - two conditions