Forum Discussion
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!
Hi Bifinity,
I tried to do it for the rest of the responses but unfortunately returning the same value as in "Park Facilities" for "Value for money" and "accessibility".
the calculated colums are returning the same value as "Park Facilities"
It might be related to the relationship between tables?
Here the desired values:
Thanks so much in advance for your time and help!
Have a great day!
Solution SageHi 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!
Hi Bifinity,
This worked perfectly 👌😁
Thanks so much for your help and time!!