SWITCH(SELECTEDVALUE

[Anonymous]

Hi,

I am using dynamic stacked by.

I have created a column which takes user input and I use this value to stack by the 100% stacked bar chart.

I have two tables involved here:

The primary table from where the measure HC_HCorFTE_ED is coming, and I have a seperate table (Age_OrgTenure_PosTenure) to get the user inputs:

Age, Time in company and Time in role.

I do not have any relationship setup between these tables.

The problem is from the output of the below calculation, I always get the TimeInRoleGroups or whatever I put in the "else" part of the SWITCH statement.

Can anyone give me a clue what could be the reason ?

Thanks

[AntonioM · Accepted solution]

Hi, 

The problem is that the calculated column is calculated at refresh and then remains constant, independent of any filters in the report itself. That means no matter what changes your user makes (including selecting from slicers) the data in that column won't change.

As it ignores slicers, it's giving you the result for if there is no selectedvalue, so always the 'else' part.