View data opposite to filtered data

[Syndicate_Admin]

Hello community, I am in need of the help of one of you. In a sales report, when I select a customer, I figure which items they have already bought so far this year, but I would also like to see the ones they have not yet bought, that is, the opposite of what is being filtered.

In this image, you can see how no customer is selected and the table of articles is complete.

In the following image you can see how when selecting a customer, only the items that SI bought so far this year are shown.

What I would need is to be able to show the opposite of what the item table is showing so that I can also see the items that that customer hasn't bought yet.

I tried generating a new table that makes an EXCEPT between the complete article table and the filtered one, but it didn't work. It seems that he compares them in the same way without taking into account the selected client, resulting in an empty table.

In advance thank you very much!

Best regards

[v-yanjiang-msft · Accepted solution]

Hi @Syndicate_Admin ,

According to your description, I create a sample.

Here's my solution.

1.Create a new table, don't make relationship between the two tables.

Table 2 = VALUES('Table'[Art.Si Comprados])

Note in the new table, you can double click the column name and modify it to Art.No Comprados.

2.Create a measure.

Measure =
IF (
    MAX ( 'Table 2'[Art.No Comprados] ) IN VALUES ( 'Table'[Art.Si Comprados] ),
    1,
    0
)

Put the Art.No Comprados column in a visual and put the measure in the visual filter, then set its value to1, get the result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[Syndicate_Admin]

Thank you very 👏🏻👏🏻👏🏻 much !!! It's exactly what I couldn't get to do! Best regards