Forum Discussion

parvathisuku_90's avatar
5 years ago
Solved

Need help with parameter

I have create a parameter named 'AssetID' I need to use the same parameter in my measure  Per Asset = CALCULATE(     AVERAGE('cbdb alarm_occurences'[qty_alarms_7day]),     'cbdb alarm_occur...
  • nandukrishnavs's avatar
    5 years ago

    parvathisuku_90 

     

    You cannot directly use the parameter inside the DAX measure. But you can create a reference of the parameter. Then it will act as a table. After that, you can use it in DAX measure.

     

    Attaching the PBIX file for your reference.

     

  • parvathisuku_90's avatar
    parvathisuku_90
    5 years ago

    How can I convert parameter to table. Can you please provide an example.

  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    parvathisuku_90 

     

    1. Open Edit Query window
    2. Right-click on Parameter
      1.  

    3. Click Reference
    4. Then click on convert To Table
      1.  

     

  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    parvathisuku_90 

     

    after = symbol, you could use selectedvalue() for getting the value.

    selectedvalue() 

     

  • parvathisuku_90's avatar
    parvathisuku_90
    5 years ago

    Thank you!!!!! Working fine...