How can i filter by string and numeric

[NOVICE02]

Hello,

hoping someone has an idea...

I wrote the following formula:

Handled = CALCULATE(DISTINCTCOUNTNOBLANK('Inbound Data'[ban]),FILTER('Inbound Data','Inbound Data'[calls_handled]="Y")

,FILTER('Inbound Data','Inbound Data'[AR_balance]<>0))

I get the error saying that the comparison cannot be supported and to use value or format to convert one of the values

but i can't seem to get it to work

[Icey]

Hi @NOVICE02 ,

Glad to hear that. Please accept your reply above as a solution.

Best Regards,

Icey

[Anonymous]

Try to run your calculation with one filter at a time to see which of the filters is causing the problem.

Also, what are the data type for the two columns in the table filter?

Thank you

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[mwegener]

Hi @NOVICE02,

could you provide sample data or a screenshot of the data 

[NOVICE02 · Accepted solution]

 Hi!,

I just solved it. I changed the numeric column to text and then added the filter to that column...

Handled_Calls2 = CALCULATE(DISTINCTCOUNTNOBLANK('Inbound Data'[ban]),FILTER('Inbound Data','Inbound Data'[calls_handled]="Y"),

FILTER('Inbound Data','Inbound Data'[AR_BALANCE1]<> "0"))