Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2020
544
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.76 KB | None | 0 0
  1. BUD SP Display =
  2. Var OrderNum = SELECTEDVALUE('IS Structure'[ORDER],999)
  3. Var CMWarehouse = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=2))
  4. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=18))
  5. Var CMDirects = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=3))
  6. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=19))
  7. Var CMFreight = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=4))
  8. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=23))
  9. Var CMOther = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=5))
  10. +CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=4.1))
  11. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=24))
  12. Var CMTotal = CMWarehouse+CMDirects+CMFreight+CMOther
  13. Var GPTotal = CMTotal + CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=54))
  14. Var TotalOverheads = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=149))+CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=94))
  15. Var IncomeBeforeTaxes = (GPTotal-TotalOverheads)
  16. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=153))
  17. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=155))
  18. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=156))
  19.  
  20. Return
  21.  
  22. SWITCH(OrderNum,
  23. 29,CMWarehouse, --CM Warehouse
  24. 30,CMDirects, --CM Directs
  25. 31,CMFreight, --CM FREIGHT
  26. 32,CMOther, --CM OTHER
  27. 34,CMWarehouse+CMDirects+CMFreight+CMOther, --CM TOTAL
  28. 36,FORMAT(DIVIDE(CMWarehouse, CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=2))),"##.##%"), --CM Warehouse Ratio
  29. 37,FORMAT(DIVIDE(CMDirects,CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=3))),"##.##%"), --CM Directs Ratio
  30. 39,FORMAT(DIVIDE(CMWarehouse+CMDirects+CMFreight+CMOther,CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=7))),"##.##%"), --CM Total Ratio
  31. 56,GPTotal, --GP TOTAL
  32. 149,TotalOverheads, --TOTAL OVERHEADS
  33. 151,GPTotal- TotalOverheads, --EBITDA
  34. 158,IncomeBeforeTaxes, --INCOME BEFORE TAXES
  35. 164,IncomeBeforeTaxes
  36. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=160))
  37. -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=161)), --NET INCOME
  38. CALCULATE([BUD SP Base Measure]) --ALL OTHER ROWS
  39. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement