how to filter array column from another array column

[YaroslavSheles]

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]

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]

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

[YaroslavSheles]

I tried this

DistinctValuesArrayColumn1 =
DISTINCT(FILTER(RELATEDTABLE(reviews_reviews),
NOT(ISBLANK(reviews_reviews[Assigned]))),
reviews_reviews[Next_Action])

the issue is:

Too many arguments were passed to the DISTINCT function. The maximum argument count for the function is 1.