Forum Discussion

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
8 years ago
Solved

SUM formula without filter interaction

Hi,   I have searched a lot of questions and answers here and could not solve my own problem   I have a table called OK_INVOICE_EXCEL   OK_INVOICE_ALL_EXCEL[FP1] is my value in USD and MUS_AD i...
  • i_kafali's avatar
    i_kafali
    8 years ago

    Thank you Greg

     

    I solved the problem 

     

    CALCULATE(SUM(OK_INVOICE_ALL_EXCEL[FP1]);ALLEXCEPT(OK_INVOICE_ALL_EXCEL;OK_INVOICE_ALL_EXCEL[Currency Selection];OK_INVOICE_ALL_EXCEL[Only Year];OK_INVOICE_ALL_EXCEL[MONTH];OK_INVOICE_ALL_EXCEL[FIRMA];OK_INVOICE_ALL_EXCEL[SAT_AD];OK_INVOICE_ALL_EXCEL[BU];OK_INVOICE_ALL_EXCEL[Subsegment];OK_INVOICE_ALL_EXCEL[Fiili/Bütçe]))