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 i...
Need Help
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"

sameergupta60's avatar
sameergupta60
Helper IV
3 years ago

Hi ,

 

I removed all the calculation column & rows but my purpose has yet not been resolved.

 

Regards,

Sameer

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    With just that one sentence no one will be able to help you.  Share the revised PBI and MS Excel file.  Remove unwanted tables/formulas/columns from the PBI file so that there is no confusion.  In another tab of the MS Excel file, show the expected result.

    • sameergupta60's avatar
      sameergupta60
      Helper IV
      3 years ago

      Hi ,

       

      in the attached file we have the input file & output files same need on power BI.

       

      Regards,

      Sameer Gupta

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        No files are attached.  Where are both the files? - PBI and Excel.  Ensure that in the Excel file, the result is shown cearly.