Forum Discussion
Helper ICategories or metadata for Columns.
In query editor, click on all the questions() and then click transform-> Unpivot Columns, you will get two new columns [Attribute] and [Value] as below:
After applied&close, you need to build a one-many relationship between these two tables as below:
Then you can create a measure to calculate the average value of Mentor in category A like pattern below:
Average_Value_Of_Mentor = CALCULATE(AVERAGE(Table1[Value]), FILTER(Table2, Table2[Category A] = "Mentor"))You can also refer to the pbix attached.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support
In query editor, click on all the questions() and then click transform-> Unpivot Columns, you will get two new columns [Attribute] and [Value] as below:
After applied&close, you need to build a one-many relationship between these two tables as below:
Then you can create a measure to calculate the average value of Mentor in category A like pattern below:
Average_Value_Of_Mentor = CALCULATE(AVERAGE(Table1[Value]), FILTER(Table2, Table2[Category A] = "Mentor"))
You can also refer to the pbix attached.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThis looks like a fantastic solution, thanks.