Forum Discussion
Measures as Row Data Fields
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 |
2 Replies
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
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.
