Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
@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]
))
Thank you @amitchandak!
I applied the formula, but I got the following error.
The syntax for 'Switch' is incorrect. (DAX(CALCULATE(SUMX('Inv. Opportunities'Switch( True(),Location[Region] ="EMEA" ,'Inv. Opportunities'[Excess Stock Value]/9.1,Location[Region] ="APAC" ,'Inv. Opportunities'[Excess Stock Value]/9.1,'Inv. Opportunities'[Excess Stock Value])))).
I tried the applying what is told in the error, it still shows error.
Hi @Anonymous ,
You have missed some comma's and closing brackets in your formula. Below code would be ideal code which Amit suggested:-
Excess Buffered Stock =
CALCULATE (
SUMX (
'Inv. Opportunities',
SWITCH (
TRUE (),
Location[Region] = "EMEA", 'Inv. Opportunities'[Excess Stock Value] / 9.1,
Location[Region] = "APAC", 'Inv. Opportunities'[Excess Stock Value] / 9.1,
'Inv. Opportunities'[Excess Stock Value]
)
)
)
Thank you,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thanks a lot! @Samarth_18 !
Can I also know how to apply the same if there is a condition?
For eg:
@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")
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
@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.
@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]
))
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |