Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

FILTER function with a List as filter condition

Hello everyone!   I have a customer who does a lot of different filterings, i.e. for Article groups and subgroups, location groups and subgroups, including changing overlap and changing groups. To ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Simply

     

    VAR ItemList = VALUES(dimProduct[ItemNumber)

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
lease use

msrQuantity =
VAR ItemList = { "12345", "54321" }
RETURN
    CALCULATE (
        SUM ( InventoryData[QTY] ),
        FILTER ( InventoryData, InventoryData[ItemNumber] IN ItemList )
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you! I'm feeling really stupid right now, I saw that a minute after I made this post. Do you have any idea how I would automatically generate such a ItemList-String variably, though? I.e. using a CONCATENATEX?

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Anonymous 
      Generate it out of what? What is the input? Also CNCATENATEX won't help you, you need a table not a scallar concatenated string value

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you so much for your help. Keeping it simple, it would be a dimProduct table that is filtered many different ways in i.a. a table visual with filter visuals next to it, so my initial thought would be replacing the List string with

         

        VAR ItemList = CONCATENATEX(dimProduct, dimProduct[ItemNumber], ",")

         

        But as you say, I don't get the right thing out of this. CONCATENATEX isn't the right function. How do I get there, though?