Different result of measure and calculated column

[Anonymous]

Hi All,

I have measure nad calculated column with same formula. Measure return correct values but column just blank values.
Coud you explain me why and how to change formula in column to get same result?
Thank you

this is my formula:

Project PM Hours distibution weeks C = 
var current_Opp_No = SELECTEDVALUE('PM Hours distribution'[Opportunity_Number])
var current_Project_Month_no = SELECTEDVALUE('PM Hours distribution'[Project Month])
var weeks = 
    COUNTROWS(
        FILTER(
            ALL('PM Hours distribution'[Opportunity_Number], 'PM Hours distribution'[Project Month], 'PM Hours distribution'[Date]),
            'PM Hours distribution'[Opportunity_Number]=current_Opp_No && 'PM Hours distribution'[Project Month]= current_Project_Month_no)
            ) 

return
IF(weeks = 0 , BLANK() ,
MIN('PM Hours distribution'[Project PM hours distribution month]) * MIN('PM Hours distribution'[PM hours]) / weeks)

[TomasAndersson · Accepted solution]

Hi!
Instead of 

var current_Opp_No = SELECTEDVALUE('PM Hours distribution'[Opportunity_Number])
var current_Project_Month_no = SELECTEDVALUE('PM Hours distribution'[Project Month])

try

var current_Opp_No = 'PM Hours distribution'[Opportunity_Number]
var current_Project_Month_no = 'PM Hours distribution'[Project Month]

I.e. by not using SELECTEDVALUE(). I can't say if that's all, but it would be one reason that you get a blank when trying to create a calculated column. Hope this helps!

[Anonymous]

Hi @TomasAndersson ,

great thank you, additionally I remove both MIN from last row and now it is working.

Thank you