Forum Discussion

billybaroo's avatar
billybaroo
New Member
8 years ago
Solved

Linked/Filtered Tables in a Report

Hello, new user with a basic (i think) question.  I have 2 tables in a report - Table A with summary data, Table B with detailed data - both tables are using the same data source (a single table).  W...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    billybaroo,

     

    You may add a measure to Table B.

    Measure =
IF (
    SELECTEDVALUE ( 'Table B'[Column1] ) = SELECTEDVALUE ( 'Table A'[Column1] ),
    1
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

billybaroo,

 

You may add a measure to Table B.

Measure =
IF (
    SELECTEDVALUE ( 'Table B'[Column1] ) = SELECTEDVALUE ( 'Table A'[Column1] ),
    1
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have the same use-case, but the solution isn't working correctly for me. 
Is there any other way to approach this problem?