How to get row total when field parameters used

[VK7]

I've created table with Name, Roll & Field parameter (English,Maths, Science). I need to calculate Percentage column by 
adding the subjects (English+Maths+Science) Divided by no. of field parameter selceted.
For Instance,
in below scenario it should be (English + Maths + Science) Divided by 3

whereas, in below scenario it should be (English + Maths) Divided by 2

Below image from Power bi.

@Rickmaurinus  

@GuyInACube 

@Curbal

[davehus · Accepted solution]

Hi @VK7 ,

The easiest thing to do is normalize your data by unpivoting it into a table. Please see attached example.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.