FIxed equivalent Power BI (Using AllExcept) not showing the data I need

[Anonymous]

Hi there!

I am new to PowerBI where as I used to use Tableau.

I really need help on how to use PowerBI correctly in terms of the 'FIXED' equivalent from tableau. 

Below is my formula in tableau:

Below is formula for Power BI:

And this is what I got (The table below is only summary):

So I did the RETURN and SUMX Values because I need to sum all the average of 'order amount by item'

The Total value showing is not aligned. 

Please help!

Thank you very much.

[Anonymous]

Let me go into detail what I mean:

Above is an example of a raw data that I have. I need to average the "Net Amount" so that it aligns with the "Billing Amount"

Below is expected data:

So, after net amount is averaged, I will total them.

I have no problems using fixed in Tableau, but in Power BI, it seems its summing the the net amount before it is averaged. Please help for any clues or directions!

[amitchandak]

@Anonymous , Change return  like

Sumx(Summarize(nonreurn_callsenter, nonreurn_callsenter[prder ifdo - order number] ,nonreurn_callsenter[prder ifdo - item id], "_1", NetAmount), [_1]) 

[Anonymous]

Sadly this does not work. 

Below formula however is getting me very close to the numbers that I'm looking for. So I put the below formula on the column while changing it to Sum.

Below is the values: (Your solution is order amount by item):

Your solution is on the most right. The formula that I show above is the avg net amount. 

The real value is on 1,660 so im getting really close, but I dont know why there is this slight difference.