Forum Discussion
Use single value to filter a row which combines multiple values
Rows need to filter A A,B,C B D B,C,D A B If use put above column to filter, it will list(A; A,B,C; B; D; B,C,D; ) What I want to see in fitler is expected filter ...
Hi Anonymous
When you say filtering A, you are talking about using Slicer to filter, and you need a DAX measure to display the reulst in a Card visual? If yes, two disconnected tables, one is filterTable in Slicer, one is rowTable. If you need to keep the original order, add an index column in Power Query
test = VAR CurFilter = SELECTEDVALUE(filterTable[Column1]) VAR T1= ADDCOLUMNS(rowTable,"check",IF(SEARCH(CurFilter,rowTable[Column],1,-1)=-1,0,1)) RETURN CONCATENATEX(FILTER(T1,[check]=1),[Column],";")
Hi Anonymous
When you say filtering A, you are talking about using Slicer to filter, and you need a DAX measure to display the reulst in a Card visual? If yes, two disconnected tables, one is filterTable in Slicer, one is rowTable. If you need to keep the original order, add an index column in Power Query
test =
VAR CurFilter = SELECTEDVALUE(filterTable[Column1])
VAR T1=
ADDCOLUMNS(rowTable,"check",IF(SEARCH(CurFilter,rowTable[Column],1,-1)=-1,0,1))
RETURN
CONCATENATEX(FILTER(T1,[check]=1),[Column],";")
This also need create another table, is there any method that not use new table?