How to apply EARLIER concept by using Dax Measure?

[Anonymous]

Hi all,

Need your help cause I can't find any solution so far.

I have a matrix visual as below with 3 columns (Product, Packsize and Price). I'm trying to write Measures for Price per ml and Price per ml of smallest Packsize.

How to write dax measure for Price per ml of smallest packsize? 

[Anonymous]

Hi @Fowmy , I know frist measure but how about the second? I just see a picture.

[Fowmy]

@Anonymous 

Sorry, I forgot to attach it, please check my reply now.

[Anonymous]

Many thanks @Fowmy 

[Fowmy · Accepted solution]

@Anonymous 

Your first measure:

Price Per ML = 
DIVIDE(
    SUM(Table2[Price]),
    SUM(Table2[Packsize (ml)])
)

Second measure:

Smallest Packsize = 
CALCULATE(
    FIRSTNONBLANKVALUE( Table2[Packsize (ml)] , [Price Per ML] ),
    ALLEXCEPT( Table2 , Table2[Product] )
)