Forum Discussion

kjartank's avatar
kjartank
Icon for Helper II rankHelper II
9 years ago
Solved

Using filter on UNION

Hi.   I have been using the "UNION" function to get my charts to be more manageable and am in need of a filter on these tables. The code I've been using looks like this. Satisfaction Score = UNION...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You would use FILTER in your first parameter. So,

     

    SELECTCOLUMNS (FILTER(Table1,[Period] = MAX([Period])); "Attribute";...

    Something along those lines. Would need sample data to get specfic.

     

    You might also want to create a variable where you filter your table and return it and then use that variable in place of Table1 in your SELECTCOLUMNS. Would be more efficient that way.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

You would use FILTER in your first parameter. So,

 

SELECTCOLUMNS (FILTER(Table1,[Period] = MAX([Period])); "Attribute";...

Something along those lines. Would need sample data to get specfic.

 

You might also want to create a variable where you filter your table and return it and then use that variable in place of Table1 in your SELECTCOLUMNS. Would be more efficient that way.

  • bsas's avatar
    bsas
    Icon for Post Patron rankPost Patron
    8 years ago

    Hi Greg_Deckler,

     

    How I can create such variable (filtered table based on slicer) and then use it selectcolumns?