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(Table[Customer]),min([Dec Sales],[Jan Sales]),CALCULATE(sumx(V_Cust_Aging, MIN([Dec Sales],[Jan Sales]))))
CompanyCustomerDec SalesJan SalesMin of Dec and Jan
100112342005050
10011235300700300
100211112501000250
  7501750750

Kindly help

 

Regards

Samar

 

2 Replies

  • 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