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
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

nope, still crashes

  • 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