Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

SUM , FIlter, Containsstring DAX Formula

¡Hola! Tengo esta fórmula de suma dax con los siguientes filtros 0RevActTransactions2 = CALCULAR( SUMA('_Facts'[Amt])*-1, FILTER(_Facts,CONTAINSSTRING(_Facts[LOOKUPLegacyTransType],"INVOICE"))...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

@juhoneyighot Probar:

0RevActTransactions2 = CALCULATE(
SUMX(,
  FILTER(
    _Facts, 
    CONTAINSSTRING(_Facts[LOOKUPLegacyTransType],"INVOICE") && 
    CONTAINSSTRING(_Facts[LOOKUPLegacyTransType],"CREDIT MEMO") &&
    '_Facts'[FH_CurrentYN] = "Yes" &&
    '_Facts'[FH_Type] = "28 Legacy AS Transactions" &&
    '_Facts'[GLAccountCategory] = "400 SALES"
  ),
  '_Facts'[Amt]
)*-1