Forum Discussion

Snoopy2020's avatar
Snoopy2020
Regular Visitor
6 years ago
Solved

LOOKUPVALUE error

Hello,   I have a model with 2 tables connected in left join (connected by branchID field - not all contracts has branchID value). Contracts: branchID Branches: branchID, destrcitID I created a ...
Need Help
  • Snoopy2020's avatar
    Snoopy2020
    6 years ago

    Hello,

     

    Thank you for your help.

    I found the solution - need to drag Contracts[BranchID] to pie values and Branches[Districts] to legend.

    My mistake was that I dragged Branches[BranchID] to pie values.

     

    Thank you fot your support.

az38's avatar
az38
Community Champion
6 years ago

Hi Snoopy2020 

if you have relationships by BranchId, you can just add DistrictID field into the visual

also, you can try add a column into your Contracts table

 

= FIRSTNONBLANK(Branches[distrcitID], 1)