Array with data that does not exist in table

[Syndicate_Admin]

Dear.

Pleasure in greeting,

I have 2 matrices, the first one shows all users, the 2nd users with surveys, I would like to have a 3rd matrix with non-surveyed users. For the example, the one who frames in red is the user who would like to show because he has no survey.

Best regards!!!

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Please refer to my pbix file to see if it helps you.

Create a table.

Table 2 = 'Table'

Then Create a measure.

Measure= IF(MAX('Table 2'[nut])=SELECTEDVALUE('Table'[nut]),BLANK(),1)

Then filter the measure.

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

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

[lbendlin]

Read about EXCEPT() and INTERSECT()   DAX functions.

Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided.