topic Percentage of target sales achieved in column. in DAX Commands and Tips

Percentage of target sales achieved in column.

pmargari — Wed, 22 Feb 2023 14:46:26 GMT

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

Re: Percentage of target sales achieved in column.

mark_endicott — Mon, 24 Jun 2024 16:18:31 GMT

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.

Re: Percentage of target sales achieved in column.

mark_endicott — Thu, 27 Jun 2024 09:46:24 GMT

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