how to filter array column from another array column

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.

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.