Calculating Values in DAX using a parameter

[Anonymous]

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 

[v-xicai · Accepted solution]

Hi  @Anonymous ,

What if parameter can only be used in measure instead of calculated column, so you can create measure like DAX below.

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

You can learn more:https://docs.microsoft.com/en-us/power-bi/desktop-what-if.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Gosh this seems so simple when you explain it that way but thank you so much! That worked perfectly! 

Austin I