slicer result to be used in column

[lilyyan]

I need to use the slicer result to dynamatically show the estimation of expense, but get stuck on how to use the slicer result. 

my design is to add a column in the table (or in other table is okay) with formular: Selected = if ( the cell of Name is selected, 1, 0); then I can do many things based on the new added column.

slicer table:

Name

A

B

C

D

E

F

G

H

I

J

K

L

M

N

[TomMartens]

Hey,

unfortunately it's not possible to use selection from slicers to populate columns in tables, this is because calculated columns are evaluated during the refresh of the data model.

Slicer are a UI component as any other visual, that interacts with the model (the refreshed model), so for this reason you just can use measures.

Maybe you can describe one of the many things you want to do, this makes things a lot easier to provide further assistance.

Regards

Tom

[lilyyan]

Hi, Tom

Thanks for your help.

the whole thing I want to do is to estimate the budget of different people with one dynamic element "location" to see the influence of location changes and determine the best location arrangement accordingly.

I have 13 people (Table 2), locating in two locations (column location in Table 2 should be calculated whether selected or not in Table 1). The final result of Column expense will vary depending on the column "location" in Table 2.

the rough column formulas:

Table 2 [location] = if (table 1[Name] is selected, "South", "North")

Expense = Cost in NonAsia * # in NonAisa + Cost in Asia * # in Asia + if (Table 2 [location] = "south", Cost in North * # in North, Cost in South * # in South)

Table 1		Table 2
Name		Name	# in Asia	# in NonAsia	# in South	# in North	Location		Table 3 Location	Round Trip Flights	Hotel	Meal	Nights	Cost
A		A	1		8	12	North		NonAsia	2000	200	75	5	3375
B		B		1	2	2	South		Other	400	150	50	5	1400
C		C	1		5	3	North		North	400	150	50	5	1400
D		D			1	2	South		South	400	150	50	5	1400
E		E			2		North		Asia	580	200	75	5	1955
F		F	3			3	North
G		G		1		3	North
H		H				3	North
I		I			3	1	North
J		J	1				North
K		K					North
L		L		2			North
M		M				4	North