I am working on a report where data is filtered by ID. There are around 2000 different ID's in that data set and I have to use only 30 of them. When the user is analyzing the data he might still want to exclude some of them (using the basic filter option).
I was wondering, which is a good function to use if I want to select only the desired 30 ID's and transfer them into a new column or measure which I will use as the visual level filter input so that the user doesn't have to search through all the other 2000 ID's? The ID's have a 4 or 5 digit value, something what is equivalent to Like% in SQL and accepts multiple values?
If I understand you correctly, you should be able to filter your ID column in Query Editor.
Click the down arrow ( ) of the column containing a Text value you want to filter on.
Click Text Filters, and click an equality type name of Equals, Does Not Equal, Begins With, Ends With, Contains, or Does Not Contain.
Or you can try running native database queries against the database to get the corresponding ID data.
@v-ljerr-msft Thank you for your replay. The text filters could be useful, but i need a DAX function since the report is going to be shared through different departments and they are going to connect to their own databases. The Id is actually a Chart of Accounts Id so that they are basically all the same for every deppartment so I have to set up something what will work universaly