Forum Discussion
LOOKUPVALUE error
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.
Thank you for your answer. Sorry, I am a newbie. I will try to explain my issue.
The problem is that Branches table contains 300 records with BranchID & DistrictID values.
Contracts table contains only 100 reocrds with BranchID value.
When I add BranchID[DistrictID] visual to Contracts report I get 300 records and not 100.
Changing the selections in Contracts report does not change BranchID[DistrictID] visual dispaly.
I want the the visual will display BranchID[DistrictID] only for records with BranchID in Contracts.
In excel it can be done with Vlookup that will search BranchID in Branches and return DistrictID if found and null if not.
How can I do it ?
Thank you
you can set aggregation as First, MIN or MAX in BranchID field in visualization pane
also you can deactivate option Show items with no data
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.