Assign numeric value to a specific text string to get an average

Hi Pamdelorbe , try this:

-  Table 1 is something like this

- Table 2 is something like this

- Create this relationship:

- Create this calculate column:

- Create this measure:

- Create another this measure:

- Create the measure to the average:

The result:

I hope you works it, Best regards

Hi Pamdelorbe , you can remove the relationships between the 2 tables, and follow this steps:

- Create (for example) this calculate columns:

The result is this:

 

- Create the measures to counts and averages:

 

The result is:

- When you insert the filelds (columns) to design the table, choose Don´t resume in this 2 column:

If you have problems let me know, 

Best regards!