Help with complex Measures and Calculated columns

Can you please share a mock excel data craigmon 

for column e,g you can use divide function in DAX

Column h, use all function to return the average value, 

Column i cna use the * operator to multiply

Column k, do an if loop to check for negative values, IF([YourColumnName] < 0, [YourColumnName],0)

Cell k14, do a sum by applying abs()

Let me know if this helps.

Hi,

Please try to have base columns as Measures created in PBI

For Ex to calculate Column E, please create a Measure for Column D & C and use DIVIDE function.

Same for Column G, Column I, Column J

For Column H = AVERAGEX(ALL('YourTable'), 'YourTable'[Column G])

Column K= Calculate(<<column J Measure>>, column J Measure<0)

K14= Calculate(<<column K Measure>>, column K Measure<0)

Hope this helps 

Hi craigmon,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to srlabhe, raji_n, for those inputs on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.

I am also including .pbix file for your better understanding, please have a look into it.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Fabric Community Forum.