Average Cost in totals

[quickbi]

Hi all,

I'm doing some calculations and one I want to analyze is the averge cost. The Average Cost is a measure:

Coste Unidad = 
DIVIDE([Median Cost],[Revenues Unidades],0)

I create a pivot table view and whe dimensions Customer & Seller are open the calculations are correct: 736 each unit

But when I collapsed the average is not an average is a sum of the cost, then is  1472

Any idea how could i show the average and not the sum?

Thanks

[v-xinruzhu-msft]

Hi @quickbi 

You can try the following measure

Coste Unidad =
VAR a =
    CALCULATE ( [Median Cost], ALLSELECTED ( table ) )
VAR b =
    CALCULATE ( [Revenues Unidades], ALLSELECTED ( table ) )
RETURN
    DIVIDE ( a, b, 0 )

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[quickbi]

Hi,
Thanks for your answer but if I apply this formula I could not filter by article

Is not possible to tell to the table when it resume by total some columns do it by sum and another by average?
Thanks again guys

[v-xinruzhu-msft]

Hi @quickbi 

Thanks for you quick reply, can you provide some sample data and the output you want so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

[elitesmitpatel]

Please share a dummy data for easy reference .