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
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"