Hello all,
Trying to work out how to filter the same column twice in Power Bi service. Here is an example
Student A Test 1 89%
Student B Test 1 72%
Student C Test 1 93%
Student D Test 1 56%
Student A Test 2 73%
Student B Test 2 86%
Student C Test 2 77%
Student D Test 2 64%
I want to build a report for each student (A-D) showing the average overall percentage vs their average overall percentage. I can't seem to make a line graph or bar chart with average overall percentage and then the average percentage of Student A only because it will only let me filter independently when I add the % value twice.
I essentially need to put the % column on twice and filter it once for average of Student A, and once for the average of all results.
I don't really want to create 2 colmuns on my excel for this as it's convoluted enough!
Any suggestions?
Thank you!
I would suggest creating a measure like this:
Measure = AVERAGEX(ALL('Table'),[Score])
Can you create measures in Power Bi Service?
Thank you
No, you would need access to the Desktop (PBIX) file.