Dax Measure crashing report

[nmaddock]

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(WeightAllowence = BLANK(), 

 //PPK 
     VAR _part1 =  [Lift Rate] - (
                    (MIN([KG's Per Lift by Actuals], MAX(Agreement[Weight Allowance KG]))) * [Disposal Costs])
             RETURN IF( NOT( ISBLANK( _part1 ) ), _part1 - [Operational Costs] ) ,
//Non PPk
    VAR _part1 =  [Lift Rate] - ([KG's Per Lift by Actuals] * [Disposal Costs])
    RETURN IF( NOT( ISBLANK( _part1 ) ), _part1 - [Operational Costs] )
)

Its basically 2 formulas based on wether I have a weight allowence on my agreement table.

My pbx file can be found here https://www.dropbox.com/s/yerlqi9979w5sti/Termination%20complete.pbix?dl=0

Many Thanks in advanced

[alicia_pbi]

@nmaddockdid you ever get this resolved?  I am having similar issues in multiple PBI reports.  I have large datasets (1M+ rows in the QE) and 30+ measures written in the report as opposed to the data set.  I am getting infinity errors on some of my measures (division against blank/zero) so I am trying to use an iferror.  When I add iferror to the measure the visual spins for hours and ends up crashing.  I am trying to avoid writing the measures in the QE as that would increase the queries necessary and add unnecessary complexity.

Thanks!

[kentyler]

You 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]

I have in the link

[kentyler]

nope, still crashes

[nmaddock]

sorry, ive removed the measure now, https://www.dropbox.com/s/l0pj9rbvrwtus7k/Termination%20complete%20-%20Copy.pbix?dl=0

[nmaddock]

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]

still crashes ever time i open it

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

[nmaddock]

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]

sorry, it crashes before i can do any clicking