Forum Discussion
Client evaluation changes - measuring progress
I'm trying to count distinct clients who have had an additional evaluation by measure only if their score per measure was greater than the prior score.
Collections intervals are 'blank' or Baseline and then 6 month or 12 month etc. The measures are titled Q_Eductation or Q_Well_Being_Pillar Score. For each measure I want to count a client (Client_Code) if for their measure they had a higher score than their previus one and report out the # of distinct clients by measure and score. The scores translate to specific progress measures
I am trying to do this in a DAX formula not a new table.
Example Results
Measure Score # Distinct Clients
Q_Educational_Attainment 32 1
Q_Well_Being_Pillar_Score 32 1
Example Data
| Client_Code | Q_Collection_Interval | Q_Educational_Attainment | Q_Well_Being_Pillar_Score | Date_Started | Date_Ended |
| C000001 | Baseline | 16 | 40 | 3/23/2022 0:00 | |
| C000631 | Baseline | 24 | 40 | 7/12/2021 0:00 | |
| C004461 | Baseline | 8 | 14 | 4/7/2021 0:00 | 6/9/2021 0:00 |
| C004596 | 18+ months | 4 | 18 | 10/26/2022 0:00 | |
| C004968 | Baseline | 16 | 32 | 6/28/2021 0:00 | |
| C005026 | Baseline | 8 | 24 | 8/17/2021 0:00 | |
| C005293 | Baseline | 12 | 10 | 8/23/2022 0:00 | 10/5/2022 0:00 |
| C006037 | Baseline | 32 | 40 | 3/11/2022 0:00 | |
| C006165 | Baseline | 4 | 14 | 8/20/2021 0:00 | 11/1/2021 0:00 |
| C006302 | Baseline | 4 | 20 | 2/24/2021 0:00 | 2/24/2021 0:00 |
| C006302 | 6-months | 4 | 16 | 8/25/2021 0:00 | 8/25/2021 0:00 |
| C007814 | 6-months | 16 | 36 | 8/25/2022 0:00 | |
| C037797 | Baseline | 16 | 18 | 3/17/2021 0:00 | 7/23/2021 0:00 |
| C037797 | 6-months | 32 | 32 | 12/15/2021 0:00 | |
| C039488 | Baseline | 8 | 6 | 5/20/2021 0:00 | 6/30/2021 0:00 |
| C043868 | Baseline | 12 | 18 | 5/13/2021 0:00 | 6/9/2021 0:00 |
| C043868 | 6-months | 12 | 18 | 1/27/2022 0:00 | |
| C043868 | 12-months | 12 | 20 | 3/15/2021 0:00 | 5/10/2021 0:00 |