Hello @supergallagher25,

So the individual formulas will be the extension of the formulas that I’ve provided above. To calculate the “Passed Once” results, below is the formula provided for the reference -

```
Passed Once - Harsh =
IF( [Passed Results] = "Passed Once" , 1 , BLANK() )
```

But as you can see in the above screenshot, the measure doesn’t provide the results of “**Grand Total**” so now to calculate the “**Grand Total**” results of measure “**Passed Once**”. Below is the formula provided for the reference -

```
Passed Once - Harsh - Total =
SUMX(
SUMMARIZE(
'Table' ,
'Table'[ID] ,
'Table'[Subject] ,
"Totals" ,
[Passed Once - Harsh] ) ,
[Totals]
)
```

Now, follow this same process for “Passed Twice”, “Passed More Than Twice” as well as for the Failed side, if required.

Finally, you’ll be able to achieve the results that you’ve been trying to showcase. Below is the screenshot of the final result provided for the reference -

I’m also attaching the working of the PBIX file for the reference.

**Important Note:**

**1. Since no person has passed/failed more than twice the results are shown as “****BLANKS**”. If there’s a data in your actual file where person has passed/failed more than twice than the formula will calculate the results and the figures will be showcased automatically.

**2. In the file, I’ve created the groups of the measures and for “Passed” and “Failed” categories alongwith the numbering provided to each measure so that you can understand how the measure flows. Below is the screenshot provided for the reference -**

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,

Harsh

VariousCounts - Harsh v2.pbix (33.2 KB)