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, 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...
  • 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.

     

     

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.