https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-gone-wild/m-p/2444080#M65543 <P>Hi,</P><P>&nbsp;</P><P>I am building out some measures and hit a snag, appreciate any advice.&nbsp;</P><DIV><UL><LI><SPAN>Measure One looks like this: A-Parts Finish =&nbsp;LOOKUPVALUE(Tasks[EndDate],Tasks[KeyMilestoneType],"A-Parts")</SPAN><UL><LI><SPAN>This works great.</SPAN></LI></UL></LI><LI><SPAN><SPAN>Mesure Two looks like this:&nbsp;</SPAN></SPAN>A-Parts Health = <SPAN>LOOKUPVALUE</SPAN><SPAN>(</SPAN><SPAN>Tasks[TaskStatus]</SPAN><SPAN>,</SPAN><SPAN>Tasks[KeyMilestoneType]</SPAN><SPAN>,</SPAN><SPAN>"A-Parts"</SPAN><SPAN>)</SPAN><UL><LI><SPAN>This works great</SPAN></LI></UL></LI><LI><SPAN><SPAN>Measure Three looks like this:&nbsp;</SPAN></SPAN>A-Parts PercentDone = <SPAN>LOOKUPVALUE</SPAN><SPAN>(</SPAN><SPAN>Tasks[PercentDone]</SPAN><SPAN>,</SPAN><SPAN>Tasks[KeyMilestoneType]</SPAN><SPAN>,</SPAN><SPAN>"A-Parts"</SPAN><SPAN>)</SPAN><UL><LI><SPAN>This one throws an error:&nbsp; <STRONG>A table of multiple values was supplied where a single value was expected</STRONG></SPAN></LI></UL></LI></UL><DIV>&nbsp;This doesn't make sense to me, any thoughts?</DIV><DIV>&nbsp;</DIV></DIV> Thu, 07 Apr 2022 16:48:13 GMT MrSQL 2022-04-07T16:48:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-gone-wild/m-p/2444080#M65543 <P>Hi,</P><P>&nbsp;</P><P>I am building out some measures and hit a snag, appreciate any advice.&nbsp;</P><DIV><UL><LI><SPAN>Measure One looks like this: A-Parts Finish =&nbsp;LOOKUPVALUE(Tasks[EndDate],Tasks[KeyMilestoneType],"A-Parts")</SPAN><UL><LI><SPAN>This works great.</SPAN></LI></UL></LI><LI><SPAN><SPAN>Mesure Two looks like this:&nbsp;</SPAN></SPAN>A-Parts Health = <SPAN>LOOKUPVALUE</SPAN><SPAN>(</SPAN><SPAN>Tasks[TaskStatus]</SPAN><SPAN>,</SPAN><SPAN>Tasks[KeyMilestoneType]</SPAN><SPAN>,</SPAN><SPAN>"A-Parts"</SPAN><SPAN>)</SPAN><UL><LI><SPAN>This works great</SPAN></LI></UL></LI><LI><SPAN><SPAN>Measure Three looks like this:&nbsp;</SPAN></SPAN>A-Parts PercentDone = <SPAN>LOOKUPVALUE</SPAN><SPAN>(</SPAN><SPAN>Tasks[PercentDone]</SPAN><SPAN>,</SPAN><SPAN>Tasks[KeyMilestoneType]</SPAN><SPAN>,</SPAN><SPAN>"A-Parts"</SPAN><SPAN>)</SPAN><UL><LI><SPAN>This one throws an error:&nbsp; <STRONG>A table of multiple values was supplied where a single value was expected</STRONG></SPAN></LI></UL></LI></UL><DIV>&nbsp;This doesn't make sense to me, any thoughts?</DIV><DIV>&nbsp;</DIV></DIV> Thu, 07 Apr 2022 16:48:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-gone-wild/m-p/2444080#M65543 MrSQL 2022-04-07T16:48:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-gone-wild/m-p/2444138#M65549 <P>Found the solution here:&nbsp;<A href="http://here" target="_self">https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-quot-A-table-of-multiple-values-was-supplied-where-a/td-p/331656</A></P> Thu, 07 Apr 2022 17:35:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/LOOKUPVALUE-gone-wild/m-p/2444138#M65549 MrSQL 2022-04-07T17:35:12Z