Show another value based on measure

Question

Hi,I have the following measure to calculate the youngest driver who has won a Grand Prix:YoungestDriver = CALCULATE(Max(drivers[dob]),FILTER(results, results[rc_position] = 1))&nbsp;The outcome is the date of the driver, however I want the driver's name, which is in table 'Driver' and column 'Name'. How can I achieve this?

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
Please have a try.
YoungestDriverName =
CALCULATE (
    LOOKUPVALUE ( drivers[name], drivers[dob], MAX ( drivers[dob] ) ),
    FILTER ( results, results[rc_position] = 1 )
)

&nbsp;
How to Get Your Question Answered Quickly&nbsp;
&nbsp;
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
&nbsp;
Best RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Show another value based on measure

2 Replies

Related content

Creating a measure that is the value of another measure but ignores a filter

SELECTEDVALUE measure from slicer keeps returning blank value when used on another measure

Cumulative Difference from Another measure

Measure returning incorrect value

Sum measure based on another measure value