cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chorri21
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
Microsoft
Microsoft

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

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

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors