Forum Discussion

Luke-Howells's avatar
Luke-Howells
Frequent Visitor
4 years ago

Measure Results to Column

Hi Experts,

 

I have a mesaure which returns to selected values from my slicer, it may be one value or multiple values:

Slicer Results = IF(ISFILTERED('02. Licence Type'[LicenceType]), CONCATENATEX( ALLSELECTED('02. Licence Type'[LicenceType]),'02. Licence Type'[LicenceType],", "),"(All)")

 

Now this works great for me but what I need to do is take the results and use them to be looked up in another table. I have a list of licence types types and want another column next to these which is a lookup that returns wether that licence type has been selected in the slicer. Or if there is another way to do this then great. Any ideas?

 

TIA. 

 

Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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)")

     

     

     

    • Luke-Howells's avatar
      Luke-Howells
      Frequent Visitor
      4 years ago

      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.