How to calculate the percentage based on column and slice selection

[Anonymous]

Hi team, I am very new to Power BI and come across my first question,  I have a table where contains the sales amount and team, dates, sample as below: 

Agent name	Agent Team	Sales date	Sales total
Lucy	Team A	30/07/2020	3
Marin	Team A	31/09/2020	2
Charcy	Team B	1/08/2020	1
Chris	Team C	2/08/2020	5

I am using Agent team as a slice in Power BI,  then I want to calculate the percentage of Sales of each person baes on my selection of teams,  for example, if I dont select any team then it will be calculated based on the whole table, the result will be like: 

	Sales total	Percentage
Lucy	3	27.27%
Marin	2	18.18%
Charcy	1	9.09%
Chris	5	45.45%

but if I select Team A, the percentage will need to calculates based on the total sales of Team A. 

	Sales total	Percentage
Lucy	3	60.00%
Marin	2	40.00%

I know we can use the "Percentage of grad total" to show similar results, but I would like to create it as a measure so I can re-use this value.

I tried to use DAX below: 

Pct Team =

VAR Personal =

sum('table'[Sales Total])

VAR ALLteam=

SUMX(

all('table'),

'table'[Sales Total]

)

DIVIDE(Personal, ALLteam)

But that won't give what I want, anyone can help pls? : ) 

[amitchandak · Accepted solution]

@Anonymous , Try with allselected

Pct Team =
VAR Personal =
sum('table'[Sales Total])
VAR ALLteam=
SUMX(
allselected('table'),
'table'[Sales Total]
)
DIVIDE(Personal, ALLteam)

[amitchandak · Accepted solution]

@Anonymous , Try with allselected

Pct Team =
VAR Personal =
sum('table'[Sales Total])
VAR ALLteam=
SUMX(
allselected('table'),
'table'[Sales Total]
)
DIVIDE(Personal, ALLteam)

[Anonymous · Accepted solution]

It worked, thanks 🙂