Drill through without physical relationship

[Anonymous]

Hi

I have two table visuals that have two separate data sources and no physical relationship between them.

Unable to create relationship because of ambiguity issues.

Is there anyway to implement drill through from vis 1 to vis 2 based on clean id (which is a texted value)?

[v-xuding-msft]

Hi @Anonymous ,

You could create an index column in the two tables and create an inactive relationship between them. And create a measure like below to drill through report.

Measure = CALCULATE(MAX('Table 2'[ID]),USERELATIONSHIP('Table'[ID],'Table 2'[ID]))

Or you could create a bridge table to connect the two table. 

[amitchandak]

@Anonymous , You can not do without common dimension. I think the date can be one. Or create one dummy dimension join with both and create drill-through using it.