Measure is not showing total value

[Kolumam]

This is my formula

Jan 2020 measure = 
var a = IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, 31*VALUE(Operation[Daily Budget measure]), BLANK())
RETURN
IF(YEAR(MAX(Operation[First_COD__c]))<>2020,
a,
IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, IF(MONTH(MAX(Operation[Budget 2020 Start Date]))=1,DATEDIFF(MAX(Operation[Budget 2020 Start Date])-1,DATE(2020,1,31),DAY)*VALUE(Operation[Daily Budget measure]), a)))

The above measure is not showing any total as seen below. How do I fix it?

@parry2k @mahoney19  @parry2k @az38 @jdbuchanan71 @mahoneypat @edhans @harshnathani @v-kellya-msft @MFelix @Ashish_Mathur @BA_Pete @ryan_mayu @kbuckvol @Alexander76877 @Petazo @Mariusz @TomMartens @Greg_Deckler @tjd @Sean @mikstra @AllisonKennedy @EricHulshof @briandpeterson @USG_Phil @vpatel55 @mwegener @v-piga-msft @tex628 @sturlaws @Vvelarde @CheenuSing @MarcelBeug @Zubair_Muhammad @v-piga-msft @danextian @MattAL @MattAllington @roalexan @Alexander76877 @kgc 

[Anonymous]

Hi @Kolumam ,

Can you provide some sample data? It will be very helpful to me.

Best Regards,

Stephen Tao

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

[amitchandak]

@Kolumam , Try like

var a = IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, SUMX(VALUES(Operation),31*Operation[Daily Budget measure]), BLANK())
RETURN
SUMX(VALUES(Operation) ,IF(YEAR(MAX(Operation[First_COD__c]))<>2020,
a,
IF(MONTH(MAX(Operation[Budget 2020 Start Date]))<=1, IF(MONTH(MAX(Operation[Budget 2020 Start Date]))=1,DATEDIFF(MAX(Operation[Budget 2020 Start Date])-1,DATE(2020,1,31),DAY)*SUMX(VALUES(Operation),Operation[Daily Budget measure]), a))))

[Kolumam]

Hi @amitchandak 

The solution didn't work. Still no total.