Measure Total

[Anonymous]

Hello,

I am struggling to get total of measure. 

I created 2 measures as below:

DEC New = CALCULATE(SUM(V_Cust_Aging[Total Over 1 Year]), DATEADD(DimDate[Date],-1,MONTH)),
JAN New = CALCULATE(SUM(V_Cust_Aging[Total Over 1 Year]), DATEADD(DimDate[Date],0,MONTH))
Third measure to compare above 2 measures as below
JAN Cal = IF( [JAN New]=0, BLANK() ,min([DEC New],[JAN New]))
but the total is not correct ignoring 

Please help me to write JAN Cal measure so that total come correct

Regards

Samar

[amitchandak · Accepted solution]

@Anonymous , based on what you using in visual (group by visual)

sumx(values(DimDate[Month]),IF( [JAN New]=0, BLANK() ,min([DEC New],[JAN New])))

Use any other group by  in place of DimDate[Month]

[Anonymous]

Thanks a lot! Amit,