Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
aasthashah_93
New Member

Filter Function

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.
2 ACCEPTED SOLUTIONS
shafiz_p
Super User
Super User

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

View solution in original post

Anonymous
Not applicable

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"
    )
)

vjunyantmsft_0-1731983635111.png


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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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"
    )
)

vjunyantmsft_0-1731983635111.png


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
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.