Ankit,
Thank you, it worked like a charm, but I have to ask. Is “blank” really being returned? I am not sure why such a simple fix would work, but the a function like COALESCE didn’t.
Ideally it shall not have that much performance impact. Only situation, I can think of is in Visual like Table/Matrix returning large number of rows where IF condition have to be checked for each row and thus impacting performance.
- good one! The +0 option didn’t even occur to me, and even if it had I would’ve expected it to perform exactly as COALESCE did. Got to admit that like @lomorris, I’m still scratching my head a bit over the fact that there was a significant difference in performance between the two.
It’s also got me wondering whether the new IF.EAGER() function could be used here to improve performance? Looping in @AntrikshSharma to get his take as well.
@lomorris You don’t need to inject filters manually when you have already done that throught the filters pane, and a filter over Customers[Customer Number] already exists in the filter context so no need to add it inside CALCULATE.
You should write your code in this way:
Total Ledger Amount =
SUM ( 'Service Ledger Entries'[Amount] )
@lomorris What’s the total computation time with Ankit’s solution? It is still slow for me, and I know the reason why it is slow, so I am unsure if adding 0 has improved your code, can you please check and confirm?