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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Using Parameter and measure combination in custom column

Hello! 

 

I have recently been struggling to using a paramter in caluclations in DAX. Currently I have been attempting to use a parameter for a user to input the years of interest. After determining the years of interest the hope is to be able to identify the range (and eventually perform specific calculations on those years. 

 

I have began this process with a simple identifying DAX code but it seems to not recognize the values correctly and I am unsure why. I will describe my process below... 

 

1. Import table (Table4) of years ([years]). 

 

2. Create parameter using the modeling tab in the desktop for values 2000-2016. DAX code seen below for paramter. 

 

"Parameter Years (strt) = GENERATESERIES(2000, 2030, 1)"

 

3. Create a measure referencing this parameter. DAX seen below. 

 

"Measure = selectedvalue('Parameter Years (strt)'[Parameter Years])"

 

4. Reference this measure in a new column. DAX seenbelow. 

 

"Identifier Column = if(Table4[Years] = [measure],1,0)"

 

When the parameter is set to 202 (or any other value) all of the values in the new custom column read 0. Although if I change the dax formula for the column to represent a number rather than the measure the formula works correctly and identifies the number I was looking for. With saying this I was wondering if there were specific limitations to using measures and or parameters in calculationsin this scenario? 

 

Thanks in advance. I would be happy to provide more information if it is needed as well! 

 

Austin I 

 

1 ACCEPTED SOLUTION
v-cherch-msft
Employee
Employee

Hi @Anonymous 

You may use below measure2 to get dynamic parameters.For example:

Measure 2 = IF(MAX(Table1[Years])=[measure],1,0)

a1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-cherch-msft
Employee
Employee

Hi @Anonymous 

You may use below measure2 to get dynamic parameters.For example:

Measure 2 = IF(MAX(Table1[Years])=[measure],1,0)

a1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

That worked perfectly thanks so much!! 

 

Austin I 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors