Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Use Measure in Mquery

Hi,   I would like to add measure in Mquery. If there is any specific function that i need to use. Problem Statement- I am using data from two views. View  1 does a complex calculation using the ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi Powerbiuser206,

     

    If you want to achieve single selection, you can use DAX function selectedvalue(), it you want to achieve multiple selections, you can use DAX function allselected(). M query doesn't support interact with slicer because M query is a data shape language while DAX is a report level language.

     

    Regards,

    Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Greg,

 

Thankyou for your quick repsonse.

Let me re phrase my question.

Is there a way to pass values from slicers to Parameters in Power BI.

 

Regards

PowerBIUser

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi Powerbiuser206,

 

If you want to achieve single selection, you can use DAX function selectedvalue(), it you want to achieve multiple selections, you can use DAX function allselected(). M query doesn't support interact with slicer because M query is a data shape language while DAX is a report level language.

 

Regards,

Jimmy Tao