topic Re: Filter several ranges of values in DAX Commands and Tips

Filter several ranges of values

palvarez8 — Tue, 23 Jul 2019 15:53:21 GMT

Hello,

Im actually trying to filter my DBase that it´s in an Excel sheet. I have my ID client number that goes from 0 to 999999. Also i has several states. For example Active/ Inactive / etc.

I managed to filter the states in Power Query. (Activa=Active) (Padrón= Client ID)

Now I only have to stay with the following ranges:

Id Number from

>=0 <=14999

>=16000 <=199999

>=950000 <= 959999

I tried using this filter but it didn´t work

Thank!!!

Re: Filter several ranges of values

parry2k — Tue, 23 Jul 2019 16:32:13 GMT

palvarez8 you can manually add or condition to filter, here in following example I have two condition

1- between 100 and 110

2 - between 500 and 600

you can add more OR conditions to meet your range requirement.

Re: Filter several ranges of values

palvarez8 — Tue, 23 Jul 2019 17:45:14 GMT

parry2k wrote:
palvarez8you can manually add or condition to filter, here in following example I have two condition

1- between 100 and 110
2 - between 500 and 600

you can add more OR conditions to meet your range requirement.

Thank! it worked. What if i want to create a measure with that conditions? What DAX formula should I use?