MTD calculation on a Divide measure

[Anonymous]

Hi All,

I'm trying to calculate the MTD in my case for CPA however the values are not adding through the dates. 
CPA is calculated as = Divide([Money Spent], [No of customers])

My calculation for CPA MTD is = TOTALMTD([CPA],DateTable[Date])

[Tanushree_Kapse]

Hi @Anonymous 

Try this: 
CPA MTD  = TOTALMTD([CPA],DATESMTD(DateTable[Date]))

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks

[amitchandak · Accepted solution]

@Anonymous , That will give ration will not add the daily ratio.

Try a measure like

CPA MTD is = calculate(sumx(values(DateTable[Date]), [CPA]),datesmtd(DateTable[Date]))

Make sure DateTable is marked as date table

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

[Anonymous]

Thanks, that worked perfectly