Below is a measure I that I have put together that works with not issues other than sometimes it returns “Blank” when there is no data to return. Customer Misc Amount = VAR miscCalc = CALCULATE ( SUM ( ‘Service Ledger Entries’[Amount] ) * -1, FILTER ( ‘Service Ledger Entries’, ‘Service Ledger…

@lomorris , My other suggestion would be to submit it to The Optimization Lab, and have it analyzed in depth by the master @AntrikshSharma . [image] Introducing A New Enterprise DNA Initiative – Optimization Lab DAX Calculations All, As an adjunct to the excellent new Opt…

Performance question based on Dax change

Power BI

BrianJ April 21, 2021, 8:11pm 4

@lomorris,

My other suggestion would be to submit it to The Optimization Lab, and have it analyzed in depth by the master @AntrikshSharma.

Brian