Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
admin11
Memorable Member
Memorable Member

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

Hi All

I have problem filter this record Docment No. = 991079980

 

_delete =
SWITCH(
TRUE(),
'GL'[Document No.] IN {991079980,30017530,30017534}, "_delete",
BLANK()
)
 

admin11_0-1613039023243.png

 

May i know where go wrong ?

I can filter the other 2 doc no.

 

Paul

1 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
jaideepnema_2-1613109684018.png

 

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 !! 😀

View solution in original post

8 REPLIES 8
jaideepnema
Solution Sage
Solution Sage

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.

 

jaideepnema_0-1613055246686.png

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

Capture.PNG

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

 

@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

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
jaideepnema_2-1613109684018.png

 

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 !! 😀

@jaideepnema yes you are correct , the number 

991079980 is not appear in the table. Thank you for your help.
Paul
jaideepnema
Solution Sage
Solution Sage

@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 ?

@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

admin11_0-1613053378630.png

 

Paul

jaideepnema
Solution Sage
Solution Sage

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

@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 ?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors