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 ap...
  • 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.

     

     

  • 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.

     

     

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

      Thanks for helping me out!