Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 specific account numbers, and looks like this:
01011..01090|01901..01902|01904..01959|01980..01998
I can then fetch that value in my measure with this variable:
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=oqnjelwsff4pr1...
@LauritzPBI_O
Apologies, perhaps I did not clarify my question. The sample data placed in your previous reply was just fine. However, the other table that contains the combination string was (and still) missing.
I'm trying to match between your written description of the requirement and the measure/column that you have provided in order to completely understand what exactly do you have and what exactly are trying to accomplish.
The measure/column that you have provided in you original post says the following
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
58 | |
50 | |
44 | |
21 | |
19 |