Forum Discussion

dhanekula1996's avatar
dhanekula1996
Icon for Helper I rankHelper I
5 years ago
Solved

Matrix sum at lower level and Average at Higher level

Hello all, I am Trying to sum the values at lower Hierarchy (Product A = 10) which inturn is the summed value.( 10 = 2+3+5). Total is the sum of values across product A (Total = New +Inprogress+..)....
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, dhanekula1996 

    Please check the below picture and the sample pbix file's link down below.

    I suggest having a table structure and data model like below.

    All measures are in the sample pbix file.

     

     

    https://www.dropbox.com/s/40f5vyps3bqxayn/dhanekula.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, dhanekula1996 

Thank you for your feedback.

Please share your sample pbix file's link here, then it will be much helpful not to create any gaps between I use sample A and you use sample B.

dhanekula1996's avatar
dhanekula1996
Icon for Helper I rankHelper I
5 years ago

Thank you so much for your help sir. I figured the problem and fixed it.