Non blank minimum of measure

[da_gze]

How do you calculate the minimum value of a measure not including blanks in power pivot?

The example clarifies the question:
https://www.dropbox.com/s/ayvk170koolx73s/Min of measure.png?dl=0

 

[gazpage]

=CALCULATE (
   Min ( Table[Column] )
   FILTER (
      Table,
      Table[Column] <> BLANK ( )
   )
)

 

[da_gze]

Does Min() also work with measures?

The example in the first post represents the "result pivot table" where the two last columns are measures. How to write the last measure is the actual question.

 

[gazpage]

Well, no. MINX does.

Replace Min in my first attempt with.

MINX (
VALUES ( Table[Column that matches the rowsin your pivottable] ),
[Measure]
)

 

[gazpage]

And I got that wrong as well...

ALLSELECTED rather than VALUES

 

[da_gze]

That does the trick...
At one point i was close to this solution but now i realize i used the wrong "Table[Column that matches the rowsin your pivottable]".
Thnx