Dax Help

[sameergupta60]

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

[Ashish_Mathur]

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]

Hi,

Please give me a solution to that query.

Regards,

Sameer 

[Ashish_Mathur]

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]

Hi ,

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

Regards,

Sameer

[Ashish_Mathur]

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]

Hi ,

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

Regards,

Sameer Gupta

[Ashish_Mathur]

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

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[sameergupta60]

Hi,

Please download the file from below link.

https://we.tl/t-YgSlfcLQmJ

Regards,

Sameer Gupta