Forum Discussion

BenPo's avatar
BenPo
Frequent Visitor
5 years ago
Solved

Measure Totals Calculation

Hello! Baseline calculation returns inventory amount for Friday if Saturday is 0/blank. if(CALCULATE(sumx(InventoryTable,InventoryTable[CountTotal]),filter(Date,Date[FiscalDayOfWeek]=7))=0, CALCU...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    BenPo , You have to try like

    Inv =if(CALCULATE(sumx(InventoryTable,InventoryTable[CountTotal]),filter(Date,Date[FiscalDayOfWeek]=7))=0,
    CALCULATE(sumx(InventoryTable,InventoryTable[CountTotal]),filter(Date,Date[FiscalDayOfWeek]=6)),
    CALCULATE(sumx(InventoryTable,InventoryTable[CountTotal]),filter(Date,Date[FiscalDayOfWeek]=7)))

     

     

    New Inv = sumx(summarize(Table, [Region], [area], [plant], [product], "_1",[Inv]),[_1])

BenPo's avatar
BenPo
Frequent Visitor
5 years ago

Thank you, amitchandak!