Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
LaurenceV
Regular Visitor

Retrieve the value from a parameter in a dax measure

Hello,

 

Let's say I have a simple table with 3 measures Total Amount, Total Quantity and Average Amount.

I have created a parameter ChooseMeasure with those 3 measures (from the modelisation menu).

I would like to create a measure in dax that multiplies the selected measure by 2 whatever the selected measure. 

 

I can display the name of the selected Measure with ChooseMeasure_SelectedMeasure= SELECTEDVALUE(ChooseMeasure[ChooseMeasure Champs])

But I can't find the way to get the value. I've tried the following but nothing is displayed

ChooseMeasure_SelecteValuex2 = 2*SelectedMeasure()

 Is there another simple way?

 

Example with a table where the measure is filtered on the filter pane to Total Amount:

Table 1.JPG

 

 

The .pbi file is here 

 

Thanks a lot

 

Laurence

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Sadly there is no EVALUATE in this corner of DAX.  For regular parameters/slicers you need to use a SWITCH statement to call up the measure corresponding to each parameter selection.

For Field Parameters you need to use the slicer that is created with the parameter.

 

lbendlin_0-1744133632582.png

 

lbendlin_1-1744133642828.png

 

View solution in original post

2 REPLIES 2
LaurenceV
Regular Visitor

thanks!

lbendlin
Super User
Super User

Sadly there is no EVALUATE in this corner of DAX.  For regular parameters/slicers you need to use a SWITCH statement to call up the measure corresponding to each parameter selection.

For Field Parameters you need to use the slicer that is created with the parameter.

 

lbendlin_0-1744133632582.png

 

lbendlin_1-1744133642828.png

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

OSZAR »