topic Re: how to filter array column from another array column in DAX Commands and Tips

how to filter array column from another array column

YaroslavSheles — Thu, 08 Feb 2024 15:24:34 GMT

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.

Re: how to filter array column from another array column

YaroslavSheles — Thu, 08 Feb 2024 15:33:46 GMT

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.

Re: how to filter array column from another array column

Anonymous — Fri, 09 Feb 2024 07:32:05 GMT

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.

Re: how to filter array column from another array column

YaroslavSheles — Fri, 09 Feb 2024 08:35:01 GMT

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