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],";")
thank you so much for your answer. i have already tried your way, but it only works for table visualization. what if i want to apply it to pie chart or bar chart? is there any other way i can do?