1. Total Quantity = SUMX(FactPurchase[ordered quantity])

2. Total Purchases = SUMX(FactPurchase,[Ordered Quantity]*RELATED(DimStock[Unit Price]))
3. Total POS = COUNT(FactPurchase[Supplier Key])

4. TOTAL FINAL PO =
CALCULATE (
    SUMX ( FactSales, FactSales[Quantity] * FactSales[Unit Price] ),
    FILTER ( FactTransaction, FactTransaction[Is Finalized] = "true" )
)

 

Cost Requirement Analysis

- Create the following Slicers
  - Year
  - Quater
  - Short Month
  - ISO Week No

- Create the following CARD Visuals
  - Total Purchase
  - Total Quantity
  - Total POs
  
- Visauls
  - Total Purchase by Buying Package( Donut Chart)
  - Total PoS of Buying Package (Donut Chart)
  - Total Purchase by Color (Vertical Bar Graph)
  - Total Purchases & PoS by Month (Line & Cluster Column Chart)
  - Table Showing Supplier,Total Purchase, Total PoS, Total Quantity (Matrix Table)
  - Table Showing Top 10 Items ordered as Stock Item and Total Purchase as Sales(Matrix Table)


DAX Measures to be created

- Outer Order
- Received Outer
- Total Final PO
- Total Non Final PO
- Total PoS
- Total Purchase
- Total Quantity
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare