Calculation to calculate a measure like (IF isnull(dimension field ) and NOT in dimension

[kishore23348]

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 

[v-angzheng-msft]

Hi, @kishore23348 
I've gotten some ideas, but I'd like to clear up some questions before posting a solution. Do you want to implement this via DAX or PowerQuery.

Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

You 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

[kishore23348]

it didn't solve my problem .

Thanks for idea on how this will work