Wrong Totals for Measure

[Anonymous]

Hi,

I created measure to get min of 2 columns, Total is not coming correct. Then I use HASONEFILTER but it giving error.

my data and measure as below:

Min of Dec and Jan= if(HASONEFILTER(Table[Customer]),min([Dec Sales],[Jan Sales]),CALCULATE(sumx(V_Cust_Aging, MIN([Dec Sales],[Jan Sales]))))

Company	Customer	Dec Sales	Jan Sales	Min of Dec and Jan
1001	1234	200	50	50
1001	1235	300	700	300
1002	1111	250	1000	250
		750	1750	750

Kindly help

Regards

Samar

[jthomson]

Why not just do something like Smaller = if([DecSales]<[JanSales],[DecSales],[JanSales])?

[Anonymous]

Hi,

Thanks for reply, I did it but the total is not coming correct. It is giving some of December Sales.

Regards

Samar