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 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?
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)
2 Replies
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)
