Set Analysis Help

[hjm35055]

Hi,

I have data that looks like below.  In a text box, I am trying to create an expression that shows the number of 100% VALID entities.  So with the example below, my answer would be 1.  I originally was doing =Count(DISTINCT {<[Validity Check] = {'Valid'}>} [Entity ID]. However this does not work because it is counting entity 1 and 2.  I loaded [Validity Check] as a dual Valid,0 and Invalid,1 in the script thinking I could do some set analysis that says count distinct entity ID where the sum([Validity Check] = 0. But could not figure out how to get that expression working.  Any help is appreciated. Thanks!

[sunny_talwar · Accepted solution]

May be try this

=Count(DISTINCT {<[Entity ID] = e({<[Validity Check] -= {'Valid'}>})>} [Entity ID]

or this if Validity Check can only ever be Valid or Invalid

=Count(DISTINCT {<[Entity ID] = e({<[Validity Check] = {'Invalid'}>})>} [Entity ID]