Forum Discussion
Helper VDrillthrough is not working correctly
It works as expected based on the active relationship. I believe you are trying to include the Problemcode as well in the active relationship.
Create a new key column in both the tables as below..
Simply, you could join the tables based on the new column to achieve what you need.
Or
you have to build a new dimension for Serial and ProblemCode as below and use that to define relationships
Serial ProblemCode Key
A A AA A B AB B C BC A A B B Note that I have removed Serial and ProblemCode from other two tables.
The graph in the overview page and drillthrough filter will use Problemcode from the new table.
If it helps, mark it as a solution
Kudos are nice too
Super UserHey BYENER ,
I'm not sure if I understand your data model 100%, but I assume that you "just" have 2 tables.
I suggest, that you create a 3rd table: ProblemCode that contains the distinct values. Relate this table to the screening table (on the many side) and the wip table (on the many side).
Use the new ProblemCode table for the table visual and also use this column for the drillthrough.
Hopefully, this provides what you are looking for if not, please consider to create a pbix that contains sample data (but still reflects your data model), upload the pbix to onedrive or dropbox and share the link.
Regards,
Tom
Helper V