How to see limited values in Tables Search

[SatyaPaleti]

Hi Friends,

How to see limited values in Tables Search? 

I am having following Data

Country	State	Sales
India	Andhra	12332
India	Karnataka	23243
India	Maharashtra	22131
India	Telangana	22313
USA	Florida	12345
USA	New Jersey	32123
USA	New York	34345
USA	Texas	54321

I have data for countries. I want to see data only for USA and I am using following expression in measure sum({<Country = {'USA'}>}Sales). Its working as expected.

But when the user wants to select specific state then it is showing all the Indian states and USA States as well like in the below screenshot

User wants to see only USA States but not Indian states. 

I am using following formula Pick(Match(Country,'USA'),State)  but when we use this formula, we are unable to make selections on the state. 

Could some one please help me how to resolve this issue?

Thanks,

Satya 

[vikasmahajan · Accepted solution]

Hi,

use if statement like :

if ( Country = 'USA',State)

in dimension.

Vikas