Selected city have to displayed in drillthrough page

[NavaneethaRaju]

Hi,

I wrote a measure for drillthrough page. and i add card visual. 

Filter on all pages i add few columns. like Market, Divison, VP Name.

This measure works when i drillthrough with out selecting any filters..

Selected state & country =
IF(
ISFILTERED(Account[Ship Country_Map]),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map])),

IF(
ISFILTERED(Account[Ship State]),
CONCATENATE("State- ",SELECTEDVALUE(Account[Ship State]))
)
)

I dragged above measure in CARD Visual.

Figure-1:

Figure 2-

After selecting one of the filter in Divison Field from (Filter on All pages)
Figure 3-

Figure 4 -

I want to display the country name on card Visual.

@amitchandak , Please help me this as soon as you can.

Thank you.

[amitchandak]

@NavaneethaRaju , the Current one expects one of the two is filtered Ship State , Ship Country_Map

you can add third one for division, use else, or just keep CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map]))

or

Switch( True() ,
ISFILTERED(Account[Ship Country_Map]) || ISFILTERED(Account[Ship State]),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map])),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map]))
)

or

Switch( True() ,
ISFILTERED(Account[Ship Country_Map]) || ISFILTERED(Account[Ship State]) || ISFILTERED(Account[Divison]),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map])),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map]))
)

[NavaneethaRaju]

Hi,

Actually division id, Divison name that are in separate Division table. we are just using one of the column in that division table in Filters on all pages in page level filter. when they try to filter one of the division name, that time only few states and counties are not displayed in Drillthrough page(Another Page). Ex: malaysia, uk states(Kent, New Hampshire). only few.

[v-kkf-msft]

Hi @NavaneethaRaju ,

Do you have an established relationship between your Account table and Division table?

In my test data, the filtered countries/states were successfully drilled through.

Best Regards,
Winniz