Forum Discussion
Use column with multiple comma separated values to filter visuals
aarushirc14 Might be best to split out your applications in Power Query Editor using a ", " separater and then unpivot those columns. Otherwise it could get messy, you would have to get a list of distinct applications for your slicer. Then you would need to write a complex selector that grabs the selected items (use DISTINCT) in the slicer and then use ADDCOLUMNS to SEARCH the MAX value of your current Applications column and return 1 or 0 if it is found or not. Then, return the SUMX of that column. Set your filter pane to filter for this measure > 0.
aarushirc14 Might be best to split out your applications in Power Query Editor using a ", " separater and then unpivot those columns. Otherwise it could get messy, you would have to get a list of distinct applications for your slicer. Then you would need to write a complex selector that grabs the selected items (use DISTINCT) in the slicer and then use ADDCOLUMNS to SEARCH the MAX value of your current Applications column and return 1 or 0 if it is found or not. Then, return the SUMX of that column. Set your filter pane to filter for this measure > 0.
Greg_Deckler I went with splitting out the Applications into rows and it worked. Thanks!
aarushirc14 Solid choice.