Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need default value along with drillthrough value in table visual

Hi Team,

I have one table with a column Source and having value A,B,C,D and based on that created two pages.

1. 1st page has one table visual with records A & B

2. 2nd page has table visual and in that C & D should be my defualt values.

 

When I drill through from 1st page by selecting either of the value (A OR B) it should drillthrough to 2nd page where I want to show the value of selected value from 1st page along with C&D.

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Then you need to create an independent table with 4 value A,B,C,D

     

    and use that in filter

     

    measure on page 1

    calculate(Sum(Table[Value]) , filter(Table, Table[Source] in values(Source[Source]) ) )

     

     

    measure on page 2

    calculate(Sum(Table[Value]) , filter(Table, Table[Source] in values(Source[Source]) || Table[Source]  in {"C", "C"}  ) )

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Amit,

      Thanks for the suggestion.

      But it's not working, I followed the same as you suggested but while drillthough from page 1 to page 2 the selected value only get carried to page 2 as we know the defualt behaviour of drillthrough.

      As I mentioned in my question - if I select value like A from Page 1 than on page 2 value of A carried and  filter the page 2 but along with that I need the value of C & D.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi amitchandak ,

        Thanks for the suggestion.

        But it's not working, I followed the same as you suggested but while drillthough from page 1 to page 2 the selected value only get carried to page 2 as this is the defualt behaviour of drillthrough.

         

        Let me rephrase my question again.

        On 1st page source value is showing A & B (Table visual)

        On 2nd page source value is showing C & D (Table Visual) 

        now when I drillthrough from page 1 by selecting value like A than on Page 2- A should be displayed along with C & D.