IF (True) Do not count x

[robin_heijt]

Hi,

I am trying to calculate in a bar chart the implementation of scores with this methodology:

Dimension:

=if([Movement Type]='Termination Voluntary' or 'Termination Involuntary', 'Implemented', 'Not Implemented')

Measure:

Count(distinct{<[OPR 2018]={'1B'}>}"Global ID")

This works fine, however what i would like is, that once a person has an implemented status, I do not want the graph to calculate the Not implemented status.

For example as shown in the below graph, the bar represents only 1 person. This person has an implemented status and not implemented due to multiple Movement types. But as the person already has been implemented, I do not want the bar chart to show to not implemented count. Is this possible?

[sunny_talwar]

I am not sure I completely understand this... but try this

Count(DISTINCT {<[OPR 2018] = {'1B'}, Name *= p({<[Movement Type] = {'Termination Voluntary', 'Termination Involuntary'}, Cycle = {'2018-2019'}>})>} "Global ID")

Count(DISTINCT {<[OPR 2018] = {'1B'}, Name *= e({<[Movement Type] = {'Termination Voluntary', 'Termination Involuntary'}, Cycle = {'2018-2019'}>})>} "Global ID")