Forum Discussion
Measure Results to Column
Luke-Howells , if the column from the same table
You can replace the name
Slicer Results = IF(ISFILTERED('02. Licence Type'[LicenceType]), CONCATENATEX( ALLSELECTED('02. Licence Type'[Col1]),'02. Licence Type'[Col1],", "),"(All)")
If the column from the joined table is filtering this same way replace the table and column in CONCATENATEX
if they are not connected or filerting
then
Slicer Results = IF(ISFILTERED('02. Licence Type'[LicenceType]), CONCATENATEX( Filter(('Table2') [Col1] in ALLSELECTED('02. Licence Type'[LicenceType])),'Tabl2'[Col1],", "),"(All)")
amitchandak , thanks for this but I don't think I understand.
I have 2 tables, one table is used for the slicer and the other contains data. I want to be able to select multiple licence types from my slicer and then be able to have a calculated column in my data table to show if that licence type has been selected in the slicer.
I have only got as far with the above as showing the results in a measure. Ideally having calculated columns would be better as I can then use these on multiple tables that I may create. Below is the structure of the tables I am working with.
Table 1 contains all my data, I want a calculated column in this table which shows if the licence type has been selected in the slicer.
Table 2 contains the column used in the slicer. This column contains a unique list of all licence types.