Forum Discussion

VK7's avatar
VK7
Frequent Visitor
4 years ago
Solved

How to get row total when field parameters used

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

Need Help
  • davehus's avatar
    davehus
    4 years ago

    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.

1 Reply

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    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.