Forum Discussion
filtering a skill matrix
I have the follwoing issue and would be happy about some advice. I am building up a skill matrix for people and would like to have a nice representation of what is the average skill per country p...
A very hacky way of doing this would be to create new columns for each skill that are numeric:
skillz 1 = SWITCH([skill 1],"+",1,"++",2,"+++",3,"++++",4)
You could create a measure like so:
Skillz 1 Average = SWITCH(ROUND(AVERAGE(Skillz[skillz 1]),1),1,"+",2,"++",3,"+++",4,"++++")