Forum Discussion

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
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

Icon for Microsoft Employee rank

Microsoft Employee

9 years ago

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

Sample data
Create a new table by enter data.
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]))
Use this measure in your visual.

Regards,

Chalrie Liao

sample20170710.pbix64 KB

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

v-caliao-msft
Microsoft Employee
9 years ago
akhiakg,

Please by using enter data

Regards,

Charlie Liao
- akhiakg
  Frequent Visitor
  9 years ago
  Hello Charlie Liao,
  
  Thanks for the quick response.
  
  The grand total is not matching for Profit and Sales, which I got the solution from you.
  
  Regards,
  Akhilesh Gupta
  - v-caliao-msft
    Microsoft Employee
    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

Related content