Do you have any nulls (or blanks) on any rows for the column LAK_NUM?
If you do, you might want to add an IF statement into your Variable to check for blanks and use a 0 value in its place. Something like
LAK_NUM = IF (ISBLANK([LAK_NUM]), 0, [LAK_NUM]
Without seeing your dataset that would be difficult to say. Generally i'd check things like:
From the data area of Power BI, you can copy the table and paste into Excel. I find that helps with the trouble shooting. Follow the data and it should start to come clear what is out of the ordinary.
I couldn't get this to work for me. When I created my expressions based on my data
Count [#"HAWB/HBL"] =
Var HAWB/HBL = [#"HAWB/HBL"]
'Your Table'[#"HAWB/HBL"] = 'HAWB/HBL')
The syntax error seems to pick on "var "hawb/hbl". I have tried without parethatsise as well and get the same issue.
Please can you help