Forum Discussion

BYENER's avatar
BYENER
Icon for Helper V rankHelper V
6 years ago
Solved

Drillthrough is not working correctly

Hi All,   I hope that someone can help me. I am using drillthrough to deepdive in the dataset. The drillthrough can be done on [problemcode]. In the drillthrough tab we can see in which processteps...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    BYENER 

     

    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

    AAAA
    ABAB
    BCBC
    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

     

     

     

     

VasTg's avatar
VasTg
Icon for Memorable Member rankMemorable Member
6 years ago

BYENER 

 

Do you have Processstep added in your drillthrough filter?

 

 

If so, Do you see it filtered for "Screening" in your detail page after drillthrough?

 

When there are no direct filter conditions, it will crossjoin to bring in all the data.

 

If it helps, mark it as a solution

Kudos are nice too

  • BYENER's avatar
    BYENER
    Icon for Helper V rankHelper V
    6 years ago

    Hi VasTg ,

     

    No, I only have "ProblemCode", because the processtep is only in 1 table.

     

    I will add an .pbix file for a better understanding.