All individuals in the same team have the same target

[rneto]

Dears

I'm getting a bit frustating here as I need 1 more step but I can't think how to solve this issue.

So I have a measure summing all individual targets for the month. Nothing complicated.

Each individual belongs to a team. If I dump my team list + measure summig targets, I will have each team target based on the persons belonging to each team.

But my problem is that I want to show the TEAM TARGET in a matrix table where it contains the person names.

So basically the applied person name filter must be disregarded and sum must be as per the persons team.

More or less something like this

As you can see the total team target remains the same for all team mates.

I have a table with D_staff list names + a unique table of the D_team list + F_tables that was used to build the target measure.

Thank you for the assistance

[v-eachen-msft]

Hi @rneto ,

You could use "merge queries" to merge these three tables to one table in the query editor.

[rneto]

Hello there

Not possible all tables have different structure.

Thanks though

[amitchandak]

Can you share the formula of team Target you are using and the expected outcome?

[rneto]

Hi there the team target has not been built in a single measure, but basically its summing both DURANTIONS from F_Gen + F_Det. this duration has been multipled by a denominator to calculate individual monthly targets.

The relationship is based on the ID column (employee level).

What I wish to accomplished is a part of showing each employee target, also to create a column where the target is not filtered down to the employee level, but also show the targets of the team that each employee belongs.

As you can see below employess belonging to team Alpha have the same sum in the Team target column.

Name	Team	Individual Target	Team Target
Alban	Alpha	1000	2500
Bianca	Bravo	500	1500
Carlos	Alpha	500	2500
Diana	Alpha	1000	2500
Elia	Bravo	1000	1500

Please advise if this is enough or you need anything else.

Thanks