disregard SELECTED FILED IN DIMENSIONS

Micki — Mon, 20 Dec 2021 21:08:46 GMT

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 ?

Re: disregard SELECTED FILED IN DIMENSIONS

stevedark — Fri, 25 Sep 2020 14:12:00 GMT

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

topic Re: disregard SELECTED FILED IN DIMENSIONS in App Development

disregard SELECTED FILED IN DIMENSIONS

Re: disregard SELECTED FILED IN DIMENSIONS