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]

    ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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]

))