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

akhiakg's avatar
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's avatar
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