DAX performance issue

Hi Anonymous 

I'd need to see the model to be able to give a more accurate answer. Can you share the pbix (by PM if necessary)?

In the meantime, I don't think it will make a massive difference but try this:

Amount =
VAR Main_Account_V2 =
    ALLEXCEPT (
        Transaction,
        Transaction[MainAccount],
        MainAccount[Libellé de compte],
        'Transaction DataArea'[Entité Juridique]
    )
VAR Min_Date_V2 =
    CALCULATE ( MIN ( Transaction[AccountingDate] ), ALLSELECTED ( Transaction ) )
VAR maxConcat_ID_ =
    MAX ( Transaction[Concat_ID] )
VAR AmountV2 =
    CALCULATE (
        SUM ( Transaction[AccountingAmountDebit] )
            - SUM ( Transaction[AccountingAmountCredit] ),
        Main_Account_V2,
        FILTER (
            ALL ( Transaction[AccountingDate] ),
            Transaction[AccountingDate] >= Min_Date_V2
        ),
        FILTER (
            ALL ( Transaction[Concat_ID] ),
            Transaction[Concat_ID] <= maxConcat_ID_
        )
    )
RETURN
    [OpeningBalance]

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers