Forum Discussion

Gaz_Chapp's avatar
Gaz_Chapp
Frequent Visitor
4 years ago
Solved

Measure to filter only required column values

Hi all, new to this and it's driving me crazy.....   I have a table column that contains many unique terminal ID numbers. I want to create a measure that shows (filters) only the specific ID's I ne...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Gaz_Chapp 

     

    Try this measure to create a new table by DAX code:

    Filtered Table = filter('Table','Table'[TransAtmEftposId] in {"9V12345D","9V54321D"})

    Original Table :

     

    Filtered Table:

     

    In Power Query add click on "Insert Step After" and use this code [add new codes with OR at the end]:

    = Table.SelectRows(#"Changed Type", each ([TransAtmEftposId] = "9V12345D" or [TransAtmEftposId] = "9V54321D"))

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos✌️!!

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi Gaz_Chapp 

 

You can use the filter DAX like these:

New Table = filter(table,table[terminal ID ] = "Specific ID")
Or
New Table = filter(table,table[terminal ID ] in {ID1, ID2,ID3,...})

And you can use these codes in the Calculation.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos ✌️!!

Gaz_Chapp's avatar
Gaz_Chapp
Frequent Visitor
4 years ago

Thanks for the reply. Unfortunately the solution did not work for me. I used a text filter and edited it manually to include the additional 30+ ID's and it worked. Not sure what it is about the measure but it doesn't like the expression, I get an error "The Expression Refers to Multiple Columns". Thanks.