Creating Measure for distinct table and dim table

[Anonymous]

I have created a Distinct table(DisAcntName) for AccountName column from one dim table(Accounts) and there is one more dim table(DimID) which contains ID column.

Now I added AccountName in slicer and ID in table visuals. if I select something in the slicer it should reflect in Table visual.

pl share the measure to the above requirement.

Note - DisAcntName table is not joined with any table. It is independent.

[v-easonf-msft]

Hi， @Anonymous 

You need to apply a filter measure to table visual filter pane.

filter =
VAR a =
    IF (
        SELECTEDVALUE ( Accounts[AccountName] ) IN VALUES ( DisAcntName[AccountName] ),
        1,
        0
    )
RETURN
    IF ( ISFILTERED ( Accounts[AccountName] ), a, 1 )

Best Regards,
Community Support Team _ Eason

[davehus]

Hi @Anonymous ,

Have you got an example that you can share?