Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to 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!
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!
Hi @TomasAndersson ,
great thank you, additionally I remove both MIN from last row and now it is working.
Thank you
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |