Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BUD SP Display =
- Var OrderNum = SELECTEDVALUE('IS Structure'[ORDER],999)
- Var CMWarehouse = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=2))
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=18))
- Var CMDirects = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=3))
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=19))
- Var CMFreight = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=4))
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=23))
- Var CMOther = CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=5))
- +CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=4.1))
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=24))
- Var CMTotal = CMWarehouse+CMDirects+CMFreight+CMOther
- Var GPTotal = CMTotal + CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=54))
- 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))
- Var IncomeBeforeTaxes = (GPTotal-TotalOverheads)
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=153))
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=155))
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=156))
- Return
- SWITCH(OrderNum,
- 29,CMWarehouse, --CM Warehouse
- 30,CMDirects, --CM Directs
- 31,CMFreight, --CM FREIGHT
- 32,CMOther, --CM OTHER
- 34,CMWarehouse+CMDirects+CMFreight+CMOther, --CM TOTAL
- 36,FORMAT(DIVIDE(CMWarehouse, CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=2))),"##.##%"), --CM Warehouse Ratio
- 37,FORMAT(DIVIDE(CMDirects,CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=3))),"##.##%"), --CM Directs Ratio
- 39,FORMAT(DIVIDE(CMWarehouse+CMDirects+CMFreight+CMOther,CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=7))),"##.##%"), --CM Total Ratio
- 56,GPTotal, --GP TOTAL
- 149,TotalOverheads, --TOTAL OVERHEADS
- 151,GPTotal- TotalOverheads, --EBITDA
- 158,IncomeBeforeTaxes, --INCOME BEFORE TAXES
- 164,IncomeBeforeTaxes
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=160))
- -CALCULATE([BUD SP Base Measure],filter(ALL('IS Structure'),'IS Structure'[ORDER]=161)), --NET INCOME
- CALCULATE([BUD SP Base Measure]) --ALL OTHER ROWS
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement