Forum Discussion
Drillthought the same field between two different tables
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/2584965
2 Replies
- amitchandak
Super User
Umadhandapani , you should only use measure 9. Advantage of selected value?
- AnonymousNot applicable
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