Use MEASURE IN Advance Query Editor.

[Anonymous]

Can I use the Selected value from the Slicer in the Advanced Editor/Power Query Editor?

[v-danhe-msft]

Hi @Anonymous,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[Anonymous]

Thanks, @v-danhe-msft, I knew about the parameter, but i wanted to try this with measure.

[Anonymous · Accepted solution]

@v-danhe-msft : For closing this ticket, I will mark this as solution, but as of now this feature is not yet available in Power BI.

Thanks

-J

[v-danhe-msft]

Hi @Anonymous,

Based on my research, we can't use the selected value from slicer in Query Editor. I suggest you can use parameter and refer to below steps.

1.I have entered some sample data like the picture below.

2.Right click the column you want to select and click the “Add as New Query” function.

3.Creta a new parameter like the below picture.

Now you can select the filtered value.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/8mmh4nbtc69px2e/Use%20MEASURE%20IN%20Advance%20Query%20Editor.pbix?dl=0

Regards,

Daniel He