How to get common data from selected value in slicer

[Sha]

 I have one table that contains business unit, client, sales.  I am trying to figure out if my selected business unit (slicer) shares the same client with other business units and get total of sales by those shared clients.  Any help would be appreciated.

[v-lid-msft · Accepted solution]

Hi @Sha ,

First of all, we can create a separate table to show the data, then we can use a measure in visual filter to filter it:

TableToCompare = 'Table'

HasSameClient = 
IF (
    AND (
        SELECTEDVALUE ( 'TableToCompare'[Client] ) IN DISTINCT ( 'Table'[Client] ),
        NOT SELECTEDVALUE ( TableToCompare[Bus unit] ) IN FILTERS ( 'Table'[Bus unit] )
    ),
    1,
    -1
)

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.

Best regards,