what if slicer math

[Big_Guy_j]

I have a slicer whose value ranges from 0 to 100. I want to multiply a column in another table by the number from the slicer. 

State

State	BF
AK	0.03860241
AL	0.02990368
AR	0.037869625
AZ	0.029887445
CA	0.02029426
CO	0.04428755
CT	0.023425235
DC	0.025203095
DE	0.03882103
FL	0.036508265
GA	0.03013148
HI	0.059656655
IA	0.025673485
ID	0.009985035
IL	0.021821625
IN	0.0594541
KS	0.02928335
KY	0.067572705
LA	0.033906755
MA	0.031680775
MD	0.02433023
ME	0.00906695
MI	0.03705643
MN	0.030228805
MO	0.064968645
MS	0.038189565
MT	0.03317278
NC	0.02833254
ND	0.05125024
NE	0.04512514
NH	0.010750035
NJ	0.021988735
NM	0.046482845
NV	0.031434785
NY	0.01717918
OH	0.049866015
OK	0.02771969
OR	0.01454571
PA	0.030100965
RI	0.03729154
SC	0.02146454
SD	0.013677265
TN	0.023567185
TX	0.03537309
UT	0.06290527
VA	0.02800104
VT	0.001125315
WA	0.00908786
WI	0.047636465
WV	0.077596075
WY	0.069102535
ZUS	0.03356684

Example code: Column ='EC - Simp'[BF]*TEST[TEST Value]

returns: Blank

running just 'EC - Simp'[BF] returns values and running TEST[TEST Value] always returns blank

[Anonymous]

Hi @Big_Guy_j,

Current power bi does not support create dynamic calculated column/table based on filter. They do not work on the same data level. I'd like to suggest you write a measure formula instead.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng