Forum Discussion
Solved
Filter on Two Columns - Same Table
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 p...
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)
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)
Is it possible to make multiple selections? ðŸ˜