Forum Discussion

sameergupta60's avatar
sameergupta60
Helper IV
3 years ago

Dax Help

Hi all,

 

we need help with the below query.

 

The row-wise avg of GPL staff is correct.

 

Row wise avg of gpl staff is correct.

 

when we at the overall total  506/2022 avg is 25 but it is showing avg  in gpl staff 22%

also sharing the backend sheet. pls help 

 

https://we.tl/t-eNCcRQBAl7

 

Please guide

Regards,

Sameer Gupta

Need Help

9 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Referring to your MS Excel file, The Zonal1 table in PowerBI Desktop rquires a lot of cleaning up.  First of all, all total and calculation columns should be removed.  Next, all columns columns other than the first 3 should be "Unpivoted".

    This is when your data would become amenable for any analysis,.

    • sameergupta60's avatar
      sameergupta60
      Helper IV
      3 years ago

      Hi,

      Please give me a solution to that query.

       

      Regards,

      Sameer 

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        Hi,

        In the file that you are feeding to PowerBI desktop, just remove all calculated columns/rows/total columns/total rows.  Once loaded, select the first 3 columns, right click and click on "Unpivot Other Columns"