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 Non-buffered stock.   Non-Buffered Stock = CALCULATE(SUM('Inv. Opportunities'[On Hand Value]),'Inv. Opportunities'[InventoryPlanning]="N...
Help required
  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    4 years ago

    Hi Anonymous ,

    Use this:

    Measure= IF(SELECTEDVALUE(Table[Region])= "EMEA", CALCULATE(SUM('Inv. Opportunities'[On Hand Value])/9.1,'Inv. Opportunities'[InventoryPlanning]="NB"), IF(SELECTEDVALUE(Table[Region])= "APAC)" CALCULATE(SUM('Inv. Opportunities'[On Hand Value])/6.7,'Inv. Opportunities'[InventoryPlanning]="NB"),  CALCULATE(SUM('Inv. Opportunities'[On Hand Value]),'Inv. Opportunities'[InventoryPlanning]="NB"))

    Mark this as a solution, if i answered your question.

    Thanks

     

Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi Anonymous ,

 

Use the below Measure:

Measure= IF(AND(SELECTEDVALUE(Table[Region])= "EMEA", SELECTEDVALUE(Table[Region])= "APAC)", CALCULATE(SUM('Inv. Opportunities'[On Hand Value])/9.1,'Inv. Opportunities'[InventoryPlanning]="NB"), CALCULATE(SUM('Inv. Opportunities'[On Hand Value]),'Inv. Opportunities'[InventoryPlanning]="NB"))


Mark this as asolution, if I answered your question. Kudos are always appreciated.

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you! Tanushree_Kapse .

    Both the regions have two different exchange rates.

    For eg: EMEA has 9.1 and APAC has 6.7

     

    How can I implement that?

     

    Thank you!

    • Tanushree_Kapse's avatar
      Tanushree_Kapse
      Icon for Impactful Individual rankImpactful Individual
      4 years ago

      Hi Anonymous ,

      Use this:

      Measure= IF(SELECTEDVALUE(Table[Region])= "EMEA", CALCULATE(SUM('Inv. Opportunities'[On Hand Value])/9.1,'Inv. Opportunities'[InventoryPlanning]="NB"), IF(SELECTEDVALUE(Table[Region])= "APAC)" CALCULATE(SUM('Inv. Opportunities'[On Hand Value])/6.7,'Inv. Opportunities'[InventoryPlanning]="NB"),  CALCULATE(SUM('Inv. Opportunities'[On Hand Value]),'Inv. Opportunities'[InventoryPlanning]="NB"))

      Mark this as a solution, if i answered your question.

      Thanks

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks a lot! Tanushree_Kapse