Creating a Dimension with Average Cost and Average Net Revenue

[ttriber]

Hi Guys,

I am totally new to Powerbi so wanted to see If someone could help me. I am trying to make a dimension for Average Cost and Average Net Revenue. I looked under the fields tab of slicers and realized there is no summarization to change to average so not sure what to do. If someone could explain it with a picture that would be great. Below is what I have so far.

[Ashish_Mathur · Accepted solution]

Hi,

Write this measure for average cost

Avg cost = average(Orders[Cost])

Hope this helps.