LookupValue issue

Question

Hello,Im quite new in PowerBI and actually would like to kindly ask you for support.I had an formula which works for few weeks, and now stopped working&gt;&nbsp;NazovOrg = if(isblank(UctDenikHelios[CisloOrg]),UctDenikHelios[Spolocnost],lookupvalue(Organizace_Helios[Nazev],Organizace_Helios[SpolocnostID],UctDenikHelios[SpolocnostId],Organizace_Helios[CisloOrg],UctDenikHelios[CisloOrg]))&nbsp;&nbsp;Yesterday it started&nbsp; to generate an error message&gt;&nbsp;A table of multiple values was supplied where a single value was expected.&nbsp;&nbsp;I have checked and corrected formats of inputs but it doesnt help. Based on some advice which I found on this community I have created new one formula:&nbsp;NazovOrg2 = if(isblank(UctDenikHelios[CisloOrg]),UctDenikHelios[Spolocnost],calculate(firstnonblank(Organizace_Helios[Nazev],"n.a."),filter(all(Organizace_Helios),value(Organizace_Helios[SpolocnostID])=value(UctDenikHelios[SpolocnostId])&amp;value(Organizace_Helios[CisloOrg])=value(UctDenikHelios[CisloOrg]))))This generates diferent one error message&gt;&nbsp;DAX comparison operations do not support comparing values of type Number with values of type Text. Consider using the VALUE or FORMAT function to convert... As I told formats are checked, and even converted in formula to value, so Im lost.&nbsp;I will be very thankfull for advice what should be checked/changed. Thank you.&nbsp;

amitchandak · Accepted Answer

Anonymous , try like
&nbsp;
if(isblank(UctDenikHelios[CisloOrg]),UctDenikHelios[Spolocnost],calculate(firstnonblank(Organizace_Helios[Nazev],"n.a."),filter(all(Organizace_Helios),value(Organizace_Helios[SpolocnostID])=max(UctDenikHelios[SpolocnostId])&amp;&amp; (Organizace_Helios[CisloOrg])=max(UctDenikHelios[CisloOrg]))))

Forum Discussion

LookupValue issue

2 Replies

Related content

lookupvalue

DirectQuery issues with Related or Lookupvalue

lookupvalue PBI

Averagex issue

LookupValue with Filter