Drillthought the same field between two different tables

[Umadhandapani]

This measure works for same table but for different table is not working. How to alter the dax,

And, also  dax to find the variance in drillthrough page, if the value differs, else return zero (both positive and negative value)

And, the last post I shared the link,
https://community.powerbi.com/t5/Desktop/Drillthrough-with-two-different-tables-with-same-fields/m-p...

[Anonymous]

Hi @Umadhandapani,

You need to confirm this filter effect has been applied to the corresponding table(the source table has a relationship to the target table and the drill-through filter also interacts with the visual which uses this formula) or that formula was not able to extract the current selections by DAX functions.
Regards,

Xiaoxin Sheng

[amitchandak]

@Umadhandapani , you should only use measure 9. Advantage of selected value?