Cross Filtering Based on Only One Column of a Table Visual

[yashwant101]

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

[Anonymous · Accepted solution]

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.

[danextian]

Hi @yashwant101 ,

As always, please provide sample data and your expected result from that in a workable format like an Excel file in the cloud. Please refer to this sticky post on how to your questions answered quickly - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...