Forum Discussion
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 ...
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.
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.