Comparison of results over years and outstanding entries

[nightingale03]

Hey All,

I am trying to replicate a report into Power BI.

I have a Full Client list, which has a many-to-one relationship with the survey result table.

These surveys are conducted 1st per quarter (3 month period).

The results are reported monthly, against that period.

I have the result count part reasonablitly solved, the bit i can't seem to create a measure of is how many results are "outstanding". ie no related entry in the right table.

the desired result would be a matrix table, with the counts of the results:

Client Name || Bad Fail || Fail || Pass || Excellent Pass || Outstanding

Any help would be appreciated.