Forum Discussion

tecumseh's avatar
tecumseh
Icon for Resolver III rankResolver III
2 years ago
Solved

A Single Value For Column Cannot Be Determined

Hi, Using up-to-date version of PBID. I'm getting an error from LOOKUPVALUE() A Single Value For Column Cannot Be Determined.... I don't understand that. I checked the Table I'm trying to g...
Need Help
  • tecumseh's avatar
    tecumseh
    2 years ago

    Thanks Anonymous ,

    I think, in the end, the issue was that I was trying create a LOOKUPVALUE from one Calc_Table to another within the same lineage. This was causing a Circular error when trying in Step 6 in the diagram below to apply the Recover Customer List from Step 5 to All Customers in Step 2.

    Instead, I duplicated the Calc Table in Step 02 and renamed it so it is no longer on the same lineage tree and I was able to apply the 21 Recovered Customers from NB_05 to the new Summary_For_Recovered Calc Table (Orange in the diagram). So now I have a Table with 133 record flagged as Recovered.

    Thanks,
    -w

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523