Can I match visuals in PowerBI

[josborne]

Hi all.  I hve a question regarding PowerBI.  I have 2 table visuals.  Each one is based on a separate table, with a link by an index number.   My intended result is to show which items from table 2 are not in table 1.  

For example, in my 'master' table I have all the customers with a specific criteria (which may be a subset of a larger customer list). In my second table, I have customers with that specific criteria which have generated revenue for a filtered month.  Some customers may not show revenue and woudl not be in that second table.  I would like to see which items are missing from table 2.

More detail:

total customers=1,000

Table 1= master list of customers on a service contract which I expect to generate revenue each month

Table 2 =  list of all customers with revenue, which I filter by month

I would like to see which customers are missing from table 2, i.e. haven't generated any revenue.

I hope that's clear.

James

[josborne]

Mate thank you very much this worked well.

[v-yaningy-msft · Accepted solution]

Hi, @josborne 

According to your description, you can try following measure as a filter in Table 1 visual filter pane.

MEASURE =
VAR _table1_customer =
    SELECTEDVALUE ( 'Table 1'[Customer] )
VAR _table2_customer =
    SELECTEDVALUE ( 'Table 2'[Customer] )
VAR _result =
    IF ( _table1_customer <> _table2_customer, 1, 0 )
RETURN
    _result

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum