Filter on Two Columns - Same Table

[smerchant]

Is there a way to filter data from two columns? For example:

C1	C2	C3	C4
A	A	oher data
B	C
C	E
D	F

I want to have a filter slicer with all the possible values within C1 & C2 to filter, if E is selected as the filter, so if I select C I shoud get row 2 and 3?

[Greg_Deckler · Accepted solution]

It is possible, by creating a disconnected table for your slicer and a measure. See attached, Page 8, Table14 and Table 4. 

Table 4 = 
VAR __table = SELECTCOLUMNS(ALL('Table14'[C1]),"Value",[C1])
VAR __table1 = SELECTCOLUMNS(ALL('Table14'[C2]),"Value",[C2])
VAR __table2 = UNION(__table,__table1)
RETURN
DISTINCT(__table2)


Measure 13 = 
VAR __value = MAX('Table 4'[Value])
VAR __c1 = MAX([C1])
VAR __c2 = MAX([C2])
RETURN
IF(__c1 = __value || __c2 = __value,1,0)

[Anonymous]

Is it possible to make multiple selections? 😭