If not working. as expected

[PBI5851]

Here is the raw data 

Client	Market	Ordered	Shipped	TM
Client1	Market1	50	10	TM1
Client2	Market1	10	10	TM1
Client1	Market2	30	15	TM2

One measure as 

MeasCounts =

    IF(sum('Table1'[Shipped]) <= 18, 1,0)

But the display i get is 

Shouldn't TM2 get 1 since their sum of shipped is less than 18 . 

[PBI5851]

i am so dumb. i had the formula created for a column , rather than a measure. 

[Ritaf1983]

All of us make these mistakes sometimes 🙂

Glad to help 🙂

[Ritaf1983 · Accepted solution]

Hi @PBI5851 
Your formula is correct.
I prepared PBIX with your data and the same formula, please download and check what did you differently.

Link to pbix 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.