title: DAX - IF lookup value empty return column value
body: <p>I'm using Power Pivot 2013, I have two table.</p>
  
  <p>(fact)Table A: Name and Value
  (dim) Table B: Name and Type</p>
  
  <p>When selecting pivottable, I want to show Type and Value but if Name.TableA can't be found in Name.TableB, instead of returning (blank) i want pivottable to return Name.TableA. I have tried VALUES() IF(VALUES) with no success.</p>
  
  <p>Thank you in advance.</p>