ignore filter selection in table having only 2 dimensions, no measures.

[onkarkulkarni]

Hi,

I am having a filter- employee and a straight table with 2 dimensions only - Region and country. no measures.

every employee belongs to a specific region and a country in that region. I need to display a table where a region (1st column) of the selected employee is displayed and a country (2nd column) shows all the countries mapped to the region (ignoring employee selection). so in short, employee selection should impact only Region dimension and not the country.

Hope I am clear with the requirement.

Regards,

OK

[Vicky_Z]

I believe set analysis expression can ignore the selection. find one example here: https://www.youtube.com/watch?v=eG4E5SwjFzE

[onkarkulkarni]

Thanks Vicky, the example shows set analysis used in a measure to ignore selection but I need it in dimension (no aggregation). I can't use set analysis in dimension.

[Kashyap_R · Accepted solution]

Hi 

First Create a variable like

vRegion 

=Concat(chr(39)&Region&chr(39),chr(44))

This will get the region based on employee selection and store it in a variable "vRegion"

Next create an Alternate state which u will find in master item like 'NoEmp'

Next Create a table with Region and Country

For region use this expression

=IF(Match(Region,$(vRegion)),Region)

Country  -  take as it is 

In Appearance section u will find alternate state their set it 'NoEmp'

Now if u select any employee the region will show for that particular employee and all the countries 

Note : if u dont want to show the countries where regions are not there just uncheck show null values from the region dimension

I hope this resolve your issue 

Thanks and Regards

Kashyap.R

[onkarkulkarni]

Thanks a lot @Kashyap_R , it's working as expected 🙂