Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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!
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 🙂
Help when you know. Ask when you don't!
nope, still crashes
Help when you know. Ask when you don't!
sorry, ive removed the measure now, https://www.dropbox.com/s/l0pj9rbvrwtus7k/Termination%20complete%20-%20Copy.pbix?dl=0
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
still crashes ever time i open it
one error message said out of memory, is there some measure doing a lot of recursion ?
Help when you know. Ask when you don't!
sorry, it crashes before i can do any clicking
Help when you know. Ask when you don't!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |