Forum Discussion

Katerina_e's avatar
Katerina_e
Frequent Visitor
8 years ago
Solved

Retrieve value for the corresponding MIN value in other column

Hello!   I have been trying to figure out that for a while and now I realize I might need some help.   To simplify, I have a table similar to this.   Customer Year Price Quantity A 1 ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Katerina_e

     

    Hi, try with this:

     

    MinPrice = MIN(Table1[Price])

     

    Quantity of MinPrice =
VAR PRI = [MinPrice]
RETURN
    CALCULATE ( SUM ( Table1[Quantity] ); FILTER ( Table1; Table1[Price] = PRI ) )

    Regards

    Victor

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

Katerina_e

 

Hi, try with this:

 

MinPrice = MIN(Table1[Price])

 

Quantity of MinPrice =
VAR PRI = [MinPrice]
RETURN
    CALCULATE ( SUM ( Table1[Quantity] ); FILTER ( Table1; Table1[Price] = PRI ) )

Regards

Victor

  • Katerina_e's avatar
    Katerina_e
    Frequent Visitor
    8 years ago

    Wow, that's easy and that looks like what I was up to. Thanks.