Forum Discussion

holidays511's avatar
holidays511
Frequent Visitor
6 years ago
Solved

calculating text column value based on another measure value

Hi guys,

 

I'm looking for some help on how to create this measure so... based on another measure value, for example the current existing measure value is MINX is on Total, which is 4.

 

Now how do i get it so this new measure i'm creating will return the Name Baz.

 

Hope it make senses.

 

Thanks.

 

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi holidays511 ,

    You can create your measures like so:

    Total = SUM('Table'[Apples])+SUM('Table'[Oranges])
    Min of Total = MINX('Table',[Total])
    Name of Min Total =
CALCULATE (
    MIN ( 'Table'[Name] ),
    FILTER ( 'Table', MINX ( 'Table', [Total] ) = [Min of Total] )
)

     

    Best Regards,

    Icey

     

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

     

2 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi holidays511 ,

    You can create your measures like so:

    Total = SUM('Table'[Apples])+SUM('Table'[Oranges])
    Min of Total = MINX('Table',[Total])
    Name of Min Total =
CALCULATE (
    MIN ( 'Table'[Name] ),
    FILTER ( 'Table', MINX ( 'Table', [Total] ) = [Min of Total] )
)

     

    Best Regards,

    Icey

     

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