How to make a slicer for parameter which takes on average value of columns

[imaindia]

Hi,

I am transitioning from Tableau to Powerbi and am stuck on a problem. 

I made a parameter that takes the average values of certain columns to filter visuals.

Please have a look at the below pictures to understand better.

I want to replicate the same in Powerbi and cannot do so by making a parameter.

This is the KPI Parameter that I created in Tableau

How it is applied in creating a chart in Tableau

 

The parameter in action:

Please help with any hints and suggestions that I can use to resolve this. Currently, this is what I did to replicate:

Not able to take averages here.

[imaindia]

@Mahesh0016 

Hey, thank you for your response. I did the same but I need averages of the values that are going to be put as parameter fields. I am not able to do that.

Can you help me in this aspect?

[Mahesh0016]

@imaindia You want to select any slicer and that slicer value passes in the parameter? if I am not wrong.

[imaindia]

@Mahesh0016 

Let me explain a bit more clearly, apologies if I was not clear.

I have a dashboard with multiple visuals which are connected to this parameter. So for example

In this dashboard I want these 2 visuals to be controlled with the help of the parameter selected KPI

for eg when I select numdirectors the average of numdirectors should be taken for the visuals.

similarly when promoters is selected both the visuals now show value with average of promoters.

I hope I am able to convey the query clearly now.

[Mahesh0016]

@imaindia  you can go with the field parameter in power bi. for more information please refer below link. Thank YOU!!!
https://youtu.be/-nqEv2YXLsU 

ELSE
Measure = 
SWITCH(

    SELECTEDVALUE(Table[Column]),
    "A",[Measure1],
    "B",[Measure2],
    Blank()
  )