Measures as Row Data Fields

[newgirl]

Hi! In our company, we let our clients answer a survey to rate the drivers of the company and we download and summarize the results for us to analyze.

Below is a sample downloaded data set:

Client	Driver 1	Driver 2	Driver 3	Quarter
A	5	2	0	Q2
B	6	4	5	Q2
C	9	1	4	Q2
D	4	8	7	Q2
E	0	7	3	Q2
F	2	0	7	Q2

In one part of the report, I need to show the average rating per driver, just like a simple table below. How do I show this in power BI considering that in order to compute the average, I need to use measures?

When I tried to place the measures in the row data, it doesn't want to. But anyway, how do I show the simple table below in my report?

	Score
Driver 1	4.33
Driver 2	3.67
Driver 3	4.33

[Mariusz]

Hi @newgirl 

You can select all Driver Columns In query editor and Click Unpivot, this will give you a table like below.

From there, you just need to drag the Drivers to a visual and average the Score. 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Hi @newgirl ,

Maybe this can be interesting for you, the result wont be shown in a table but your only goal is to display information you can have something like that

You can use the card visual (this one) : 

Then add Drivers 1, 2 and 3 to the fields of the visual. 

Data will first be shown as a sum, which you can change to display average instead :

(it's in french but it should look similar 😉 )

Regards, 

Etienne