Forum Discussion

krikas's avatar
krikas
Icon for Helper I rankHelper I
6 years ago
Solved

Use value from table to filter in other table

Hi    In my example here I have a one table in my model containing: TaskId, Team allocated to task (if any), City for task   My report has two tables: The first table lists all tasks. The...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi krikas ,

     

    I see what you mean, but if you don't use slicers, the context of the measure is affected by the table content you click on.

    If you don't want to use slicers, you need to create a new replication table without creating relationships.

    Sample .pbix

     

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

V-lianl-msft please provide your pbix file.

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi krikas ,

     

    I see what you mean, but if you don't use slicers, the context of the measure is affected by the table content you click on.

    If you don't want to use slicers, you need to create a new replication table without creating relationships.

    Sample .pbix

     

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