Couldn't creat the dynamic parameter

[akhiakg]

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]

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

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]

@akhiakg,

Please by using enter data

Regards,

Charlie Liao

[akhiakg]

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 · Accepted solution]

@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