Power BI derived measure in Drop down slicer

[Anonymous]

Hi Experts,

I need your help.

I have a value coming from data source "Number of sales" . Using this value i have drived below measures in DAX using New Measure option in desktop

1. Average sales

2. % of sales with positive feedback

3. % of sales with negative feedback

Can we create a slicer, where in the dropdown, we will have above drived three measures. And when i select any one, i see its value in the table.

Thanks

[v-jayw-msft]

Hi @ShanayaK ,

Please create a new table contains the names of measures as slicer and refer to the following measure to create a new measure:

Measure 3 =

SWITCH (

    SELECTEDVALUE ( 'Table (2)'[Column1] ),

    "Measure", [Measure],

    "Measure 2", [Measure 2],

    "NA"

)

Result would be shown as below:

Hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.