disregard SELECTED FILED IN DIMENSIONS

[Micki]

Hi folks, 

how to disregard filed that was selected in dimension

IF (GetSelectedCount(Id_Title) = 0, 
COUNT({<[State]-={'Removed'},WorkItemType={'Task'},[IsCurrent]={'True'}>}DISTINCT 
[ItemSK]
), 
count(AGGR(distinct ([WorkItemLevel2] ), [WorkItemLevel2])))

And second:

=IF(GetSelectedCount(Id_Title) = 0, Id_Title, [WorkItemLevel2])

And naturally in selection bar appears two fileds Id_Title and WorkItemLevel2, and my question how to disregard the  Id_Title in set expression or simply drop filed Id_Title ?

[stevedark]

Hi @Micki 

When you have a calculated dimension any fields which are involved in that calculation are selected when a dimension value is clicked on. Unfortunately it is not possible to get around this easily.

The first thing that springs to mind is that this should perhaps be a measure rather than a dimension anyway, as it gives a numeric result. If you are looking to have the user select on the resultant value this won't work.

If the output is a table a different way of approaching this would be to have two calculated dimensions, one the count of Id_Title and the other the count of WorkItemLevel2. You can then switch between them by using a show hide condition on the two columns GetSelectedCount(Id_Title) = 0 and GetSelectedCount(Id_Title) <> 0 respectively.

Hope that helps.

Steve