Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Array with data that does not exist in table

Dear.

Pleasure in greeting,

CristianPM20_0-1648045441941.png

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's avatar
    Anonymous
    4 years ago

    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.

     

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.