Forum Discussion
Help with filtering table based on filter string
I hope someone can help with this problem. So I'm trying to create a DAX measure, that needs to filter some account numbers in a table based on a string. The string contains both ranges and speci...
Hi LauritzPBI_O
would you please clarify a bit more. Which column is which. Would be great if you could provide some sample data along with the expected result.
Hey thanks for looking into it!
I couldn't seem to attach a file here, so I've made the simplified dataset as a table here.
So ideally I need to sum the values in the "Amount" column, but only for the accounts in "AccountNo" column, that has to be filtered by the filterstring.AccountNo Amount 01001 100 01005 100 01010 100 01020 100 01021 100 01022 100 01023 100 01024 100 01025 100 01026 100 01027 100 01028 100 01029 100 01030 100 01031 100 01032 100 01033 100 01034 100 01035 100 01037 100 01039 100 01080 100 01085 100 01090 100 01100 100 01105 100 01110 100 01115 100 You may upload to any cloud or file transfer service and share the download link.
Ahh my bad!
Here's a link for the example file, its a simple Excel file with two columns
https://www.dropbox.com/scl/fi/asyxrlaf1kr6tfgu9kkzp/Example_Accounts.xlsx?dl=0&rlkey=oqnjelwsff4pr1iq7o8uc8qou
