disconnected table as slicer

[BORUCH]

Hi good afternoon

I have this measure

Average sales:=AVERAGE('ALL SALES'[GROSS AMT])

i have another disconnected table called sales increase

which looks like this

10%

20%

30% etc...

<tbody>
</tbody>

i would like to be able to * my average sales by 10 % or 20 % whatever i select with my slicer how do i go about doing this ?

 

[akice]

Average times Slicer Value :=  [Average sales] * MAX( 'Sales increase'[Value] )

 

[BORUCH]

HI

it doesn't work when I try to slice my data ittells me to create a relationship I would like to be able to select 5% or 10 %and it should times it by that number

 

[BORUCH]

Any updates on my question ?

 

[akice]

You added the slicer to the relevant pivot table? Assuming you have things setup correctly, then it should work even if you get the "no relationship" warning message. Hard to say without seeing the workbook. If i can think of something else to try i'll post later.