Hello, I have a doubt about how this problem should be solved.
I have two tables, Table A has information about new personnel that enters my company, while table B has the initial requeriment for that personnel that was needed in a certain area. I can relate both through multiple common columns (month of expected entry/month of start for the employee ; analist in charge of the process; zone that requires the personnel , etc...).
Simplified Table A:
Simplified Table B:
I can relate both tables so a graphic can show the amount of personnel required and the amount that actually entered based on the criteria I decided to match (eg. month expected to enter/month of actual entry), however, if I want to further filter/segment the data based on more criteria (eg. analist, zones...) then it just filters the table I put as the origin of data for the graphic and doesn't relate other columns even if they have common data.
Example: I relate the "Analist in charge" column. The graphic returns the total personnel requested for the analists and the count of IDs that entered under charge of the analist. If I want to use a data segmentation based on "Month of Entry", I cannot relate this column with the "Month expected to enter" as PBI doesn't let me relate multiple columns. So I end up having to use 2 data segmentations, one based on the month on Table A and the other on the month on Table B just so numbers align.
Initial Graphic:
Graphic once I filter through "Month of Entry" From Table A:
The Table B data has not changed.
Is there a way to filter through different columns? I know a solution could be merging columns but with how my data is formatted I doubt it's a useful solution, as my numbers for A are done through a COUNT() function while B has regular Sum Agreggation from PBI. Thanks in advance for any advice.
