Forum Discussion
Calculation to calculate a measure like (IF isnull(dimension field ) and NOT in dimension
how to write a calculation field to achive below functionality IF (isnull(dimension field )) and NOT in of dimension2("value1","Value2")) then measure 1 end
mahoneypat
Microsoft Employee
Microsoft EmployeeYou can create a custom column with this syntax for that logic
= if ([Dimension1] = null and not List.Contains({"Value1", "Value2"}, [Dimension2])) then "x" else null
Pat
it didn't solve my problem .
Thanks for idea on how this will work