Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Card visual drillthrough - Variable -Related Table

Hello  community.

 

I have the following issue. I want to create drillthrough on a card visual and get information from a related table.

 

So i noticed the below : 

When  I use a simple custom variable ( example : customers = DISTINCTCOUNT(myvariable)  ) , adding this on the drill through variables on the drill through page ,everything works fine. Please keep in mind that both, card and drill through page, are generated by the same table.

 
 Example : 

 

Drill through page :

Before Drillthrough :

 

 After Drillthrough 

 

 
Without the custom variable drill through is not working.
 
 
So now i want to do something similar. i use the same approach  but on the drill through page i use a related table.
 
Please check the details: 
variable : 
#Customers_RC = DISTINCTCOUNT(Customers_without_Risk_category[KNB1_Customer_ID])
 
graphs : pie and card 
 

 

 

 

relation 

 

 


Drillthrough fields :

 

So when i use the pie's drill through, filtering works fine, i suppose block_by_credit field did all the work

 


 

result in drill through page / related table :

 


 

 

When i use the card's drill through 

 

Filtering is not working at all. 

 

 

Could you please help me ?

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Dear PowerBI  and Anonymous ,I will try  again to make it clear with more printscreens

     

    I have 3 tables, two with just one column and a detailed one

    Both connections ara many to many with cross filter direction = both 

     

     

     

    I created two different cards for each one column for each table.

     

     

     

    for both tables a created a custom measure (i read that this is the only way to have a drillthrough option when you use "card")

     

     

     

     

     

    In the detailed table i dragged and dropped all those measures , even the variables

     

     

    So when i use the drill through option for both cards the detailed table is not responding/No filtering

    So could you please tell me what i am doing wrong.

     

    • The 2 tables have a many to many connection with the detailed one (filter = both) (i read this on a topic for related table - drill through)
    • I created a custom measure to enable the drill through for the card visual  (i read this on a topic drillthrough for cards)
    • I dragged and dropped all the measures - even the variables i use on my measures - in the drillthrough box
    • The reporting table is not responding.