Measure calculating fixed average price per month

[nnouchi]

Greetings all,

Is there a way to calculate a fixed average price by month? I’m required to factor in a set measure cost for avg unit prices per month.

Right now I can obtain a fixed price for all orders but am unsure on how to do this by month.

Formula for the average sale price per unit:

Avg Sale Price Per Unit = CALCULATE(DIVIDE(SUM(‘Warranty_Costs’[Net_Sales]),[Total Warranty Cores],1),ALLSELECTED(Warranty_Costs))

Any help would be greatly appreciated, thanks!

Nic

[v-frfei-msft]

Hi @nnouchi ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

[nnouchi]

@v-frfei-msft 

Here is the link: https://1drv.ms/u/s!Arkqtt9CdWCtggC74fm2Qcz8MmAX

[v-frfei-msft · Accepted solution]

Hi @nnouchi ,

To use VALUES function could get the excepted result here.

Avg Sale Price Per Unit m = 
CALCULATE (
    DIVIDE ( SUM ( 'Warranty_Costs'[Net_Sales] ), [Total Warranty Cores], 1 ),
    ALLSELECTED ( Warranty_Costs ),
    VALUES ( 'Warranty_Costs'[Date].[Year] ),
    VALUES ( 'Warranty_Costs'[Date].[Month] )
)

[nnouchi]

Thank you for the help, I was able to get my expected result through this function:

Avg Price Per Core By Month =

CALCULATE([Avg Sale Price Per Unit],

ALLEXCEPT(Warranty_Costs,Warranty_Costs[Month/Year]),VALUES(Warranty_Costs[Month/Year]))