Forum Discussion
Dax Help
Hi All, I was hoping you could help me on creating a Dax Expression as i'm new to DAX Commands. I'm trying to Filter out a specific name in column called 'Intervention' and another name in 'P...
Basically i'm trying to use a group count (thousands of lines) / Metric met for this particular vaccine to get an overall percentage of those that have and haven't met the metric.
There are 24 other vaccines inside vaccination name that need to be filtered out.
| InterventionName | Service | GroupCount | Vaccinated | NotVaccinated | VaccinationUnknown | Metric | Metric Not Met |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RN | 3 | 3 | 0 | 0 | 1 | 2 |
| Typhoid | RN | 3 | 3 | 0 | 0 | 1 | 2 |
| Typhoid | RN | 2 | 2 | 0 | 0 | 1 | 1 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 1 | 0 |
| Typhoid | RN | 4 | 4 | 0 | 0 | 0 | 4 |
| Typhoid | RN | 2 | 2 | 0 | 0 | 0 | 2 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 1 | 0 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 1 | 0 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 1 | 0 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 2 | 2 | 0 | 0 | 0 | 2 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RN | 2 | 2 | 0 | 0 | 0 | 2 |
| Typhoid | RN | 2 | 2 | 0 | 0 | 0 | 2 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 4 | 4 | 0 | 0 | 1 | 3 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RN | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
| Typhoid | RAF | 1 | 1 | 0 | 0 | 0 | 1 |
