Need default value along with drillthrough value in table visual

[Anonymous]

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.

[amitchandak]

@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]

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]

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.