Filter option to take Max range only

[JustinDoh1]

I am trying to create Dax calculated measure where I originally have two ranges to bring in as condition.

I was able to create Dax calcuated measure with both Min and Max range, but I would like to only use Max.

Here is an illustration:

I was able to use this DAX and it worked fine.

Measure =
   CALCULATE(
            VALUES(Star[Value]),
   FILTER(
       Star,
       Star[Min] <= Sum(Test[Test])
        && Star[Max] >= SUM(Test[Test])
    )
)

But, I would like to only use one column (Max) instead of using two columns (with Min).

So, this is what I am trying to envision.

MeasureNEW =
  CALCULATE(
           VALUES(Star[Value]),
  FILTER(
     Star,
     Star[Max] >= MAX(Test[Test])
   )
)

How do I accomplish it?

[Anonymous]

@JustinDoh1 

There is no such thing as "a calculated measure." There are measures or calculated columns/tables.

[JustinDoh1]

Thanks for correction. All new for me now 🙂

[wdx223_Daniel]

MeasureNEW =
  CALCULATE(
           MIN(Star[Value]),
  FILTER(
     Star,
     Star[Max] >= MAX(Test[Test])
   )
)

[JustinDoh1]

@wdx223_Daniel 

I got value of all 1 as results instead.