Finding the Average of a Sum Measure (pictures included)

[JCBI1023]

Hello Community,

Thank you for your continued help.

I have a line and clustered column chart. The bar graph shows  total wholegoods (iventory) and the line graph shows total sales. I then included a slice to filter the chart by MAKE of equipment.

The table at the bottom shows Make - Total Wholegoods -- %GT Total Wholegoods -- Sales -- %GT Sales. To measure the total wholegoods, I sum'ed each month's Wholegoods value i.e. April Sales = SUM('April Inventory'[April Wholegoods]) and then created a 'Total Wholegoods' meaure: Total Wholegoods = [April Sales] + [December Sales] + [February Sales] + [January Sales] + [March Sales] + [November Sales] + [October Sales]

Now, what I need is to find the Average Total Wholegoods Per Month. Essentially another column here: 

That shows the Averge Wholegoods Per Month. For example, when the 'Elliot' make is selected, take the wholegoods per month values and find the average:

Thank you.

[MagnusSvendsen]

Dear All,

I have found the networking days between our confirmed delivery date and shipment date. If we ship according to what we have confirmed to the customer, the value will be 2.

Now I need to find a value that tells me, how many deliveries, we ship according to what we promised = value = 2.

Therefore I need to have a %number, which says how many % of the column networking days = 2.

In the below case, if we imagine that it was all our deliveries for November, we delivered 33,33%. on time.

Networking days is a measured value

[v-huizhn-msft · Accepted solution]

Hi @JCBI1023,

Please create a measure to calculate the Average Total Wholegoods Per Month.

Average=CALCULATE(SUM(Table[Wholegoods]),ALLSELECTED(Table))/CALCULATE(DISTINCTCOUNT(Table[Month]),ALLSELECTED(Table))

I create the following sample table and test.



Create a bar chart, the x-axis is month, the Y-axis shows the total of value. Create a measure to get average.

Average = DIVIDE(CALCULATE(SUM(Table4[Value]),ALLSELECTED(Table4)),CALCULATE(DISTINCTCOUNT(Table4[Month]),ALLSELECTED(Table4)))

Please see the screenshots below, and get expected result.

  

Best Regards,
Angelia