How to create a column expression to filter certain invoice number ?

[admin11]

Hi All

I have below expression working fine :-

_LONG OVERDUE = IF( AR[Customer/Vendor Code] IN { "A10002", "AR10012" }, 0, 1 )

I try to convert the above expression to below :-

_LONG OVERDUE INVOICE = IF( AR[AR Invoice Number] IN { "122598" }, 0, 1 )

I get error msg below :-

Function 'CONTAINSROW' does not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

My objectives :-

Create a column expression for use for Slicer.

Below link is my PBI sameple file :-

https://www.dropbox.com/s/onqln2ja7gjpu8e/PBT_V2021_392%20TI_SI_GL%20FILTER%20INVOICE%20NUMBER%20OF%...

Paul Yeo

[PhilipTreacy]

@admin11 

Hi Paul,

The answer from @Jihwan_Kim  is correct.  I just wanted to add why.

In your original code you were checking for a string (text) becaue you had the Invoice Number in double quotes.

_LONG OVERDUE INVOICE = IF( AR[AR Invoice Number] IN { "122598" }, 0, 1 )

But the Invoice Number is a number so you have to supply a number to check (don't use double quotes)

_LONG OVERDUE INVOICE = IF( AR[AR Invoice Number] IN { 122598 }, 0, 1 )

regards

Phil

[Jihwan_Kim · Accepted solution]

Hi,

Please try the below.

_LONG OVERDUE INVOICE (JihwanKim) = IF( AR[AR Invoice Number] IN { 122598 }, 0, 1 )

I hope it helps.

Thank you very much.

Did I answer your question? Mark my post as a solution!