Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX formula

Hi all,   I have used the formula below to calculate the excess buffered stock.   Excess Buffered Stock = CALCULATE(SUM('Inv. Opportunities'[Excess Stock Value]))   There are 3 regions NA, EME...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Hoping region part of the same table

     

    CALCULATE(SUMX('Inv. Opportunities'

    Switch( True() ,

    [Region] ="EMEA" ,[Excess Stock Value]/9.1,

    [Region] ="APAC" ,[Excess Stock Value]/9.1, // change as per need

    [Excess Stock Value]

    ))

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Could you please elaborate a bit with example? Do you need below code to be added in provided solution or you need to calculate both in a same measure?

Non-Buffered Stock = CALCULATE(SUM('Inv. Opportunities'[On Hand Value]),'Inv. Opportunities'[InventoryPlanning]="NB")

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Samarth_18 , I would like to add exchange rates like the previous measure. So I would like know what could be the solution for the formula above.

 

Non-Buffered Stock = CALCULATE(SUM('Inv. Opportunities'[On Hand Value])/9.1,'Inv. Opportunities'[InventoryPlanning]="NB")

 

In the above formula, I would like to divide the on Hand value with repected exchange rates, and I would not want to apply that for the InventoryPlanning which has NB.