My expression cannot delete one of the rec from Document No.

[admin11]

Hi All

I have problem filter this record Docment No. = 991079980

_delete =

SWITCH(

TRUE(),

'GL'[Document No.] IN {991079980,30017530,30017534}, "_delete",

BLANK()

)

May i know where go wrong ?

I can filter the other 2 doc no.

Paul

[jaideepnema]

Hi @admin11 
i can see the aggregation applied on the document no column is Sum due to which you are getting a document no 991079980.

I checked the same document no in your data ie :GL table and the same number is not available (screenshot below)

Please accept this as a solution if your question has been answered. Appreciate a Kudos !! 

[admin11]

@jaideepnema 

Thank you for your reply . 

look like you know where is the issue ?

But i still not sure what you are trying to tell me. 

My issue is i need to remove the big -ve number , as because this large -ve value it make 2019 Rev become zero.

Paul

[jaideepnema · Accepted solution]

Hi @admin11 

Change the column as shown below

_delete = 

SWITCH(

TRUE(),

'GL'[Document No.] IN {991079980,30017530,30017534,30017532}, "_delete",

BLANK()

)

This will give you the desired result

Here is the link in case you want to download the file

https://we.tl/t-4mwNawcaZb

Please accept this as a solution if your question has been answered

Appreciate a Kudos !! 😀

[admin11]

@jaideepnema yes you are correct , the number 

991079980 is not appear in the table. Thank you for your help.

Paul

[jaideepnema]

@admin11 
if you want to explicitly filter the three values you can exclude them by applying a visual level filter 

If not can you share a sample file with sensitive data removed ?

[admin11]

@jaideepnema 

I prefer to use expression to filter those 3 value label from Document No. field name.

https://www.dropbox.com/s/a9fjl3s67d566hw/GL_ISDN_v015.pbix?dl=0

Above is my PBI file

Paul

[jaideepnema]

@admin11 Not very clear have you tried applying a visual level filter ? does that help ?

[admin11]

@jaideepnema 

Thank you for sharing

basicslly I try to use expression to filter 3 items , it only manage to filter out 2 items , one items cannot be filter. 

not sure why ?