Forum Discussion

YaroslavSheles's avatar
YaroslavSheles
New Member
2 years ago

how to filter array column from another array column

Hi! How to filter column 2 from column 1? the result should be in column 3. In each row, the length of arrays is different.  
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi YaroslavSheles

 

For your question, I modified your dax.

 

"reviews_reviews"

 

Create a measure.

 

Measure = 
    CALCULATE(
        MAX('reviews_reviews'[Next_Action]), 
        FILTER(
            RELATEDTABLE('reviews_reviews'), 
            'reviews_reviews'[Assigned] <> ""
        )
    )

 

 

Here is the result.

 

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

 

 

Regards,

Nono Chen

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

 

  • YaroslavSheles's avatar
    YaroslavSheles
    New Member
    2 years ago

    Hi. Good try.
    Your solution work when you need exclude column with one variable.
    In my case it's array column = multiple variable in one cell

     

     

     it is not works