cancel
Showing results for
Did you mean:
Helper III

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

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

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

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.
2 REPLIES 2
Microsoft

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

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

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.
Helper III

That worked perfectly thanks so much!!

Austin I

Announcements

#### Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors