Percentage of target sales achieved in column.

[pmargari]

Hello all,
I wonder if this scenario could be done in power bi ?
I would like to have in column , that will be the same for all rows, that will show the achievement of the team for the team objective.
With a visual like this :
At row level each salesrep sales and the red and green, column space, will indicate the % of target achieved by all versus team target.

 

It’s possible to do something like this ? 

Appreciate your tips / help,
KR

[mark_endicott]

@pmargari - Did my solution work? Please could you mark it as the solution if yes, this helps other users find it. 

[mark_endicott]

Yes, perfectly possible, you just need to include REMOVEFILTERS( ) and the column name. An Example of this would be below:

CALCULATE( SUM( Sales[Sales Amount] ), REMOVEFILTERS( Sales[Representative ID] ))

This removes the filter context of the Representative ID column and calculates for all Representatives. 

If this helps, please mark it as the solution.