Conditional formula if system trade = exception trade&System customer code = exception customer co

[Anonymous]

Hi, I want to apply two conditions from two different table . please help with correct power bi conditional formula. 

If system [trade] = exception [trade]&&System [customer code] = exception [customer code] then "Exception" orelse "No Exception" 

[amitchandak · Accepted solution]

@Anonymous , are you trying to create a new column or new measure

In the case of a new column

new column in system

if(isblank(countx(filter(system, system[trade] = exception[trade] && System[customer code] = exception[customer code]),system[trade] ) ), "No Exception" ,"Exception")

new column exception

if(isblank(countx(filter(exception, system[trade] = exception[trade] && System[customer code] = exception[customer code]),exception[trade] ) ), "No Exception" ,"Exception")

Also refer: https://www.youtube.com/watch?v=czNHt7UXIe8

[littlemojopuppy]

Try this

IF(
	AND(
		[Condition 1] = TRUE(),
		[Condition 2] = TRUE()
	),
	"Exception",
	"No Exception"
)