Forum Discussion

akhiakg's avatar
akhiakg
Frequent Visitor
9 years ago
Solved

Couldn't creat the dynamic parameter

 

Hi,

 

I've two measures Sales and Profit, but I want to create a  dynamic parameter for sales and profit, how can I do it?

 

Regards,

Akhilesh Gupta

  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    akhiakg,

     

    Measure =
    var selecteditem = MAX(Slicer[Slicer])
    return if(selecteditem="Sales",MAX(Sales[Sales]),MAX(Sales[Sales])-MAX(Sales[Cost]))

    change MAX to SUM

    Measure =
    var selecteditem = MAX(Slicer[Slicer])
    return if(selecteditem="Sales",SUM(Sales[Sales]),SUM(Sales[Sales])-SUM(Sales[Cost]))

     

    Regards,

    Charlie Liao

5 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    akhiakg,

     

    I have tested it on my local environemnt, the steps below are for you reference.

    1. Sample data
    2. Create a new table by enter data.
    3. Create a measure on Sales table
      Measure =
      var selecteditem = MAX(Slicer[Slicer])
      return if(selecteditem="Sales",MAX(Sales[Sales]),MAX(Sales[Sales])-MAX(Sales[Cost]))
    4. Use this measure in your visual.

    Regards,

    Chalrie Liao

    • akhiakg's avatar
      akhiakg
      Frequent Visitor
      9 years ago

      Hello Chalrie Liao,

       

      I used the logic several times, which I got from you, but not working and showing the below error in screenshot.....

       

      Please suggest and how can do it.

       

      Regards,

      Akhilesh Gupta