Using calculation in DAX while comparing

[Anonymous]

Hello guys,

I have this measure.

Focus Group = VAR TotWeeks = INT(1*(LASTDATE(Data[Order Create])-FIRSTDATE(Data[Order Create]))/7)+1

RETURN

IF([Quantity per Order]>500,3,

IF([Quantity per Order]<=500 && [Quantity per Order]>100 && COUNTA(Data[Sales Document])>=TotWeeks,2,

IF([Quantity per Order]<=500 && [Quantity per Order]>100 && COUNTA(Data[Sales Document])<TotWeeks,3,

IF([Quantity per Order]>=100 && COUNTA(Data[Sales Document])>=26,1,

IF([Quantity per Order]>=100 && COUNTA(Data[Sales Document])<26,2,3)))))

My TotWeeks variable is giving me the number of weeks between two dates that a user is selecting from a Date filter.

Now in the BOLD part above, I want to replace "26" by "TotWeeks/2", but whenever I do that, my tables start showing weird data.

With 26:

With TotWeeks/2:

I have tried many things like putting INT(TotWeeks/2), or DIVIDE(TotWeeks/2), or ROUNDUP(TotWeeks/2,0) and none of them work. I have also tried looking at the results of these variations in a card value, and it shows up all good there. But just inside this measure I am not getting the correct value.

PLEASE HELP!