The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
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 |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |