Filter Function

Hi aasthashah_93  Try this if works:

CALCULATE(
    SUM(BRS[Amount (in AED)]),
    FILTER(
        BRS,
        BRS[Reason / Remark] = "Debited in Bank not in Book" ||
        BRS[Reason / Remark] = "Debited in Bank not in Book +" ||
        BRS[Reason / Remark] = "Debited in Book not in Bank" ||
        BRS[Reason / Remark] = "Debited in Book not in Bank +"
    ),
    BRS[CFO Scorecard Group] = "BU"
)

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

Hi aasthashah_93 ,

Thanks for shafiz_p's reply!
And aasthashah_93 , another way:

Measure = 
CALCULATE(
    SUM(BRS[Amount (in AED)]),
    FILTER(
        BRS,
        BRS[Reason / Remark] IN {"Debited in Bank not in Book", "Debited in Bank not in Book +", "Debited in Book not in Bank", "Debited in Book not in Bank +"} && BRS[CFO Scorecard Group] = "BU"
    )
)

Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the replies as the solution to help the other members find it more quickly.