Analysis from group data

Hi peterpan ,

Thanks for the reply from Ashish_Mathur  and AllisonKennedy , please allow me to provide another insight:

1. Create a calculated column.

Quality of Work Rating = 
SWITCH(
    'Table'[Field],
    "Quality of Work", SWITCH('Table'[User Input], "Very Good", 5, "Good", 4, "Average", 3, "Poor", 2, "Not Proper", 1),
    BLANK()
)

2. Create a calculated table.

Table 2 = 
UNION(
        SELECTCOLUMNS(FILTER('Table', 'Table'[Field] = "Rating"), "ID",'Table'[ID],"User", 'Table'[User], "Rating", 'Table'[User Input]),
        SELECTCOLUMNS(FILTER('Table', 'Table'[Field] = "Quality of Work"),"ID",'Table'[ID], "User", 'Table'[User], "Rating", 'Table'[Quality of Work Rating])
    )

3. Create a relationship.

4. Create a measure.

Measure = 
IF(MAX('Table'[Field]) = "Target Value",1)

You can change the values ​​in the matrix to the average you want.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.