User Profile
aasthashah_93
New Member
Joined 1 year ago
User Widgets
Contributions
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.Solved616Views0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.