Tableau to Dax

[vikram412singh]

Hello, can anyone please help me, how can I convert this Tableau function into Dax 

(IF ISNULL([Nt Cogs])or [Nt Cogs]=0 or [Nt Cogs]=[Nt Unit Mrp]
THEN
{INCLUDE [Store Id],[Nt Product Id],WEEK([Invoiced At]):SUM(IF ABS([Nt Cogs])> 0 THEN [Nt Cogs] ELSE NULL END)/
SUM(IF ABS([Nt Cogs])> 0 THEN [Nt Quantity] ELSE 1 END)}*abs([Nt Quantity])
ELSE (ABS([Nt Cogs]))
END)

Thanks

[Greg_Deckler · Accepted solution]

@vikram412singh Would be easier if you just posted sample data and expected result.

IF => IF( <logical test>, <true>, <false>)

ISNULL => ISBLANK()

WEEK => WEEKNUM

SUM => SUM

ABS => ABS

SUM IF => SUMX(FILTER(...),...)