Filter Function

[aasthashah_93]

Hello,

As I want to filter the data twice 
For Eg - 

CALCULATE(SUM(BRS[Amount (in AED)]),

FILTER(BRS,BRS[Reason / Remark]) = "Debited in Bank not in Book" & "Debited in Bank not in Book +" & "Debited in Book not in Bank" & "Debited in Book not in Bank +" , FILTER(BRS,BRS[CFO Scorecard Group] = "BU"))

It showing me as error as 
A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

[shafiz_p · Accepted solution]

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

[Anonymous · Accepted solution]

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.

[shafiz_p · Accepted solution]

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