Using the same data twice (With variations) in a visual

[Anonymous]

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!

[Greg_Deckler]

I would suggest creating a measure like this:

Measure = AVERAGEX(ALL('Table'),[Score])

[Anonymous]

Can you create measures in Power Bi Service?

Thank you

[Greg_Deckler]

No, you would need access to the Desktop (PBIX) file.