Or condition in the filter

[Anonymous]

Hello,

I want to filter the data based on "OR" conditions. So, I wrote the below code:

Revenue = CALCULATE(sum('values'[[Values]]]),filter('values','values'[GDR] = "BILLED_REVENUE"||"UNBILLED_REVENUE")) but the code returns zero. What am I doing wrong?

If I just take one of the above then the code returns the actual data.

[Ashish_Mathur]

Hi,

Try this measure

Revenue = CALCULATE(sum('values'[Values]),filter('values','values'[GDR]="BILLED_REVENUE"||'values'[GDR]="UNBILLED_REVENUE"))

Hope this helps.

[mahoneypat · Accepted solution]

Please try this version of your measure

Revenue = CALCULATE(sum('values'[[Values]]]),'values'[GDR] IN {"BILLED_REVENUE", "UNBILLED_REVENUE"})

Also, it looks like you have extra square brackets in your SUM part.  Please confirm that is correct.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Thank you for the reply. For some reason the extra ] bracket is suggested by the intelligence. The code runs just fine with it.