Filter Context of Table or Measures

showy123 — Mon, 11 Dec 2023 09:51:17 GMT

The following initial situation:

The evaluation considers measured values of characteristics in fruits. In our example, Brix and pH. In the real case there are about 25 Specs which are tested.
A range is to be controlled via the slicers in order to filter the table and find out which products comply with the ranges.

The blue table shows the initial values for each fruit.

The Measure M_SpecName_Lower/Upper check whether the lower or upper value is within the set range.
If the lower and upper values are within the range, the fruit is marked with a 1 1.
If only the lower or upper value is within the range, only the corresponding measure is given a 1.

The measure for determining the 1 marking has this structure. it is underlined in red because we use German words. I have replaced these with English words to make it easier to understand.

Now to the goal:
For example, I am looking for an apple with Brix 38 to 45 and pH between 6 and 10.

This evaluation should find fruits that fit my characteristics.
I want to see Apple1 and Apple2.
Apple1 hits all ranges, apple2 hits only one at pH.But that is enough to want to see it. I don't want to see apple3, because one characteristic with upper and lower values is not in the range.

So the general rule should be.
I select the features I want to see in SpecParamType. Then I set my ranges. As soon as a fruit in one characteristic does not have both values within the limit, it should not be displayed.

What is the best way to implement this?

Re: Filter Context of Table or Measures

Anonymous — Wed, 13 Dec 2023 02:59:42 GMT

Hi showy123 ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create numerical parameters.

Brix = GENERATESERIES(0, 50, 1)

pH = GENERATESERIES(0, 20, 1)

(3)We can create a measure.

Flag = IF(MAX('Table'[Brix Lower]) >= MIN('Brix'[Brix]) && MAX('Table'[Brix Upper]) <= MAX('Brix'[Brix]) && MAX('Table'[pH Lower])>= MIN('pH'[pH]) && MAX('Table'[pH Upper]) <= MAX('pH'[pH]),1,0)

(4) Place [Flag=1] on the screening of the visual object and then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

topic Re: Filter Context of Table or Measures in DAX Commands and Tips

Filter Context of Table or Measures

Re: Filter Context of Table or Measures