Using a measure in a calculated column

[Kwiggi]

I have created a measure that will give the average cost for one item type in the column
Average Regular:=CALCULATE(AVERAGE('GE Fuel'[Cost per Quantity]),'GE Fuel'[Fuel Product Type]="UNLEADED REGULAR GASOLINE")

This seems work well. I would like to used this measure in a calculated column to give the Net average price =[Quantity]*[Average Regular]
This will give a result but only for those rows that match the filter , I would like the calculation to work on the rows that are not equal to the filter
i.e. if my Average in the measure is $2.15 I would like 2.15 to be multiplied on all rows.

I am struggling to teach my self PowerPivot and DAX, is what I am trying to do possible? I would appreciate any help.

 

[Matt Allington]

You are not alone in your struggle. The reason you are struggling is because Power Pivot is fundamentally different to Excel, and you currently don't know what those differences are yet. You can learn it, but you just need some help.

Read my article here Calculated Columns vs Measures in DAX - Excelerator BI

if you want a well structured guide that will get you where you want to be quickly, then consider reading my book - I wrote it for people just like you and it will help you, I promise. Http://xbi.com.au/learndax