Forum Discussion
nmaddock
Helper I
6 years agoDax Measure crashing report
Hi, Please can someone help, I've created a measure which seems to crash my report: GP Per Lift (13w Avg) =
VAR
WeightAllowence = MAX(Agreement[Weight Allowance KG])
RETURN
IF(WeightAllow...
kentyler
Solution Sage
6 years agoYou have to provide us with a copy of the file with the offending measure removed. Otherwise it crashes every time we try to open it :)
nmaddock
Helper I
6 years agoI have in the link
- kentyler6 years ago
Solution Sage
nope, still crashes
- nmaddock6 years ago
Helper I
sorry, ive removed the measure now, https://www.dropbox.com/s/l0pj9rbvrwtus7k/Termination%20complete%20-%20Copy.pbix?dl=0
- nmaddock6 years ago
Helper I
Even this statement crashes the report: If(WeightAllowence = Blank(), 10, 20)
I need to check if there i a weight allowence, or there is another measure called 'Is PPk' which I could use as its the same check
Thanks Nathan