Count/average based on another column

So what are your expected results from the example data?

Hi safetyfirst,

>>I'm trying to calculate the number of inspector observations per report name. 

You can create a table visual, select the report name and count of Inspector Observations as values, or you can create a new table by clicking "New Table" under Modeling on Homepage. Please review the picture1 and picture2.

Table = SUMMARIZE(Table2,Table2[Report Name],"the number of inspector observations",COUNTA(Table2[Inspector Observations]))

picture1picture2
>>I want to calculate the average number of observations per name at inspection.

You use the same way as above, select Average of Inspector Observations, or create a new table as follows.

Measure 2 = DIVIDE(DISTINCTCOUNT(Table2[Inspector Observations]),COUNTA(Table2[Name at Inspection]))

picture3

Create a new table.

Table 2 =
SUMMARIZE (
    Table2,
    Table2[Name at Inspection],
    "Average of Inspector Observations", DIVIDE (
        DISTINCTCOUNT ( Table2[Inspector Observations] ),
        COUNTA ( Table2[Name at Inspection] )
    )
)

Please let me know if this is not what you want.

Best Regards,
Angelia