calculating text column value based on another measure value

[holidays511]

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.

[Icey · Accepted solution]

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.

[Icey · Accepted solution]

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.

[holidays511 · Accepted solution]

Hi @Icey ,

Thanks for the help, its working 🙂