title: Power BI: Assign measure value to calculate column
body: <p>assign measure value to calculated column</p>
  
  <p>I have created two tables:</p>
  
  <p><a href="https://i.stack.imgur.com/qeo4l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qeo4l.png" alt="enter image description here"></a><a href="https://i.stack.imgur.com/H6l61.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H6l61.png" alt="enter image description here"></a></p>
  
  <p>User can see green field as slicer in sheet and on select, i have created measure in id_indicator table,</p>
  
  <p>Measure will take one value, that user selects from slicer</p>
  
  <p>Measure 5 = if(COUNTROWS('Input_Threshold') = 1, sum('Input_Threshold'[Green]), BLANK())</p>
  
  <p>I want to assign ([measure 5]  * [by_hour]) to field calculated but it is not working, giving black (I tried calculated = [measure 5] but still not working)
  Is it possibe to assign measure value to calculated column? </p>
  
  <p>Below it says measure5 has value 60
  <a href="https://i.stack.imgur.com/nFaVV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nFaVV.png" alt="enter image description here"></a></p>
  
  <p>But while at assigning column values it takes blank value as 'else' part says.</p>
  
  <p><a href="https://i.stack.imgur.com/NlVbt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NlVbt.png" alt="enter image description here"></a></p>