SumProduct formula with Power BI

[gmasta1129]

Hello,

I have a formula (see below) in excel that needs to be converted for Power BI.  

How would I write this formula in Power BI?

=IF(A2="","",IF(SUMPRODUCT(($D$2:$D2=D2)*($C$2:$C2=C2))>1,0,1))

Column D = CUST_NO

Column C = CUSTOMER

Column A = CUST_CLASSIFICATION

[wdx223_Daniel · Accepted solution]

CalculatedColumn=IF(ISBLANK(Table[CUST_CLASSIFICATION]),BLANK(),IF(COUNTROWS(FILTER(Table,Table[CUST_NO]=EARLIER(Table[CUST_NO])&&Table[CUSTOMER]=EARLIER(Table[CUSTOMER]))),1,0))