Forum Discussion

FilipVDR's avatar
FilipVDR
Icon for Helper II rankHelper II
3 years ago
Solved

concatenate filtered id's

Hi,

I made some sample data, what I want to do is filter on Region or Type and "Test" should only give me the selected id's.

Now Test = CONCATENATEX(VALUES('Table'[Id]),'Table'[Id],", ")

How to apply the filter context? 

 

 

  • Kazu's avatar
    Kazu
    3 years ago

    Thanks. Now I found the reason. Your measure is not created as a measure. It is a column. Choose "New measure" instead of "New column" and input exactly the same formula. When defined as a masure, its icon should look like my Test3 below.

     

     

11 Replies

  • Kazu's avatar
    Kazu
    Icon for Helper II rankHelper II
    3 years ago

    I am not an expert but once created a similar measure and filters worked just fine. How about below?

     

    Test = CONCATENATEX(Table, Table[Id], ", ")

     

    • FilipVDR's avatar
      FilipVDR
      Icon for Helper II rankHelper II
      3 years ago

      That is what I have now, but my string is always every ID. It needs to keep only the ID's which will be filtered. 

      • Kazu's avatar
        Kazu
        Icon for Helper II rankHelper II
        3 years ago

        Isn't this what you want, or am I misunderstanding.

         

         

    • Kazu's avatar
      Kazu
      Icon for Helper II rankHelper II
      3 years ago

      Thanks. Now I found the reason. Your measure is not created as a measure. It is a column. Choose "New measure" instead of "New column" and input exactly the same formula. When defined as a masure, its icon should look like my Test3 below.