Forum Discussion
PBI5851
Helper V
Helper VIf not working. as expected
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 .
Hi PBI5851
Your formula is correct.
I prepared PBIX with your data and the same formula, please download and check what did you differently.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
