Forum Discussion

nmaddock's avatar
nmaddock
Icon for Helper I rankHelper I
6 years ago

Dax 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...
Need Help
nmaddock's avatar
nmaddock
Icon for Helper I rankHelper I
6 years ago

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

  • kentyler's avatar
    kentyler
    Icon for Solution Sage rankSolution Sage
    6 years ago

    still crashes ever time i open it

    one error message said out of memory, is there some measure doing a lot of recursion ?

    • nmaddock's avatar
      nmaddock
      Icon for Helper I rankHelper I
      6 years ago
      It is, i removed the offending measure, try clicking one of the industry types to add a filter on. There are loads of records, adding that measure on i get the error your getting now
      • kentyler's avatar
        kentyler
        Icon for Solution Sage rankSolution Sage
        6 years ago

        sorry, it crashes before i can do any clicking