cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Chorri21 Frequent Visitor
Frequent Visitor

Data Filtering

Hy,

 

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?

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: Data Filtering

Hi @Chorri21,

 

If I understand you correctly, you should be able to filter your ID column in Query Editor.

  1. Click the down arrow ( Down arrow ) of the column containing a Text value you want to filter on.

  2. Click Text Filters, and click an equality type name of Equals, Does Not Equal, Begins With, Ends With, Contains, or Does Not Contain.

filtercolumn.PNG

 

Or you can try running native database queries against the database to get the corresponding ID data. Smiley Happy

 

SQLNATIVE.PNG

 

Regards

Chorri21 Frequent Visitor
Frequent Visitor

Re: Data Filtering

@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