Hey guys, can someone please help me with a QlikView expression translation into DAX? This one should summarize customer transactions (grouped by customer) and then summarize them only if they are higher than 0. I have been sitting here the whole day trying to redo all our QV reports into PowerBI and I am really brain dead after doing this for 8 hours straight . FaceTime
Sum ({< [transaction type] = {'I','R','N','C','D'},
[Week Start] = {'<=$(vReportWeek)'},
[customer key] = {'=Sum ({<[transaction type] = {''I'',''R'',''N'',''C'',''D''}, [Week Start] = {''<=$(vReportWeek)''}>} [transaction amount]) > 0'}
>} [transaction amount])
