Forum Discussion

yashwant101's avatar
yashwant101
Icon for Helper III rankHelper III
2 years ago
Solved

Cross Filtering Based on Only One Column of a Table Visual

Hi all,

 

I have 2 table visuals. Both the tables have same columns. Both have a unique key and data associated to them. In the first table we have just the latest record for the unique key and the second one has historical values for each key. The requirement is that when I click on a row in the first table, the secon one shiuld show the historical values of that key. Right now it is filtering based on all columns and I am getting the latest row in blow table as well, where I want the complete history. 

 

For now I have duplicated the table in data modeling, created a relationship between the tables on unique key and used them. Is there any othr way to achieve this?

 

Regards,

Yashwant

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi yashwant101 ,

    Below is my table1 :

    Below is my table2 :

    You can create a measure:

    Measure = 
VAR _a = SELECTEDVALUE('Table (2)'[ID])
RETURN
IF(SELECTEDVALUE('Table'[ID]) = _a  , 1 , 0)

    And then you can apply this measure to table2:

    Then the final output is shown in the following figure:

    Best Regards,

    Xianda Tang

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

2 Replies