DAX Measure - CountIF the unique ID is more than 19

[Anonymous]

Hi,

I've got the following measure, that gives me the number of Dev areas a person has which are either T or AT at a gven point in time. There are 24 areas in total, 5 don't count. I then need to count the number of UId that have a result of 19 so I can then calculate an overall percentage.

I'm a bit stuck on counting the UId's and would appreciate any help.

TIA
Ann

[mahoneypat]

Not totally sure what result you need.  Some sample data with the expected answer would be helpful to give a specific solution.  FYI on a better way to write the above, but I used DISTINCTCOUNT instead of COUNT.

NewMeasure = CALCULATE(DISTINCTCOUNT(TR_Pupil_EYFS[Unique Identifier]), EYFS_Typicality[Typicality] IN {"T", "AT"}, NOT(TY_Pupil_EYFS[Development Area] in {"People & Communities", "The World",  ...})

Pat

[Anonymous]

So the final answer I need is 4.

I've got 4 people who have a total count of 19 (Where the dev area is T or AT)