Forum Discussion

mvcsharepointde's avatar
mvcsharepointde
Icon for Helper II rankHelper II
1 year ago

RelationShip field is always empty

I have 2 tables inside Power BI desktop:-   1) GetEmployees. which has those 2 main fiels; EmployeeCode + JobCode 2) GetTimeLedgerEntry. which has this field; EmployeeCode     now i am sh...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
1 year ago

"the JobCode inside the report will be empty" - what fields are in the table visual shown? Are there empty JobCodes in the table GetEmployees?

--

Put a test visual on the page with EmployeeCode and JobCode from only the GetEmployees table (no aggregations). Do you see all the values you expect? If so, add and COUNT(EmployeeCode) from the TimeLedgerEntry table.

Does that work?