The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All
I have problem filter this record Docment No. = 991079980
May i know where go wrong ?
I can filter the other 2 doc no.
Paul
Solved! Go to Solution.
Hi @admin11
Change the column as shown below
_delete =
SWITCH(
TRUE(),
'GL'[Document No.] IN {991079980,30017530,30017534,30017532}, "_delete",
BLANK()
)
Here is the link in case you want to download the file
Please accept this as a solution if your question has been answered
Appreciate a Kudos !! 😀
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 !!
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()
)
Here is the link in case you want to download the file
Please accept this as a solution if your question has been answered
Appreciate a Kudos !! 😀
@jaideepnema yes you are correct , the number
@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 ?
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
@admin11 Not very clear have you tried applying a visual level filter ? does that help ?
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 ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
76 | |
61 |
User | Count |
---|---|
276 | |
129 | |
124 | |
100 | |
89 |