DAX SUM AND FILTER USING ALL

[Anonymous]

Hi, I am looking for some help...

I have created the below to return the sum value of 3 specific GL accounts. This works fine until I add a filter on the page for report as name ( which I have built in as ALL to the below ) and once I do this one of the account values drop off

** the report as name I’m trying to filter on has no entries in the GL which is dropping off.

TOTAL CWSR ALL (ALL) = CALCULATE(SUM(MemberReturns[Amount]),FILTER(VALUES('MemberReturns'[G_L_Account_No]),('MemberReturns'[G_L_Account_No]="4555"||MemberReturns[G_L_Account_No]="4886"||MemberReturns[G_L_Account_No]="4558")),ALLSELECTED('Date'),ALL('Report As')) 

[kentyler]

You might need to add the possibility to your OR statements that the MemberReturns[G_L_Account_No] is blank