Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Wrong Totals for Measure

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(Tab...
jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

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

 

Regards

Samar