⚙️ What Are DAX Measures?

DAX (Data Analysis Expressions) measures are used in Power BI to create custom calculations on data models. Below are the key DAX measures used in this project.

These measures powered the core KPI visuals in the dashboard.

• 💰 Total Revenue

  SUM(salesdb_orders[TotalAmount])

  Displays the total revenue generated from all transactions.

• 🔢 Total Orders

  DISTINCTCOUNT(salesdb_orders[OrderID])

  Calculates the unique count of orders placed.

• 📈 Average Order Value

  DIVIDE([Total Revenue], [Total Orders])

  Determines the average revenue per order.

• 📦 Total Inventory Units

  SUM(salesdb_products[StockQty])

  Shows total quantity of all products in stock.

• 🚨 Low Stock Product Count

  CALCULATE(COUNTROWS(salesdb_products), salesdb_products[StockQty] < 100)

  Returns the number of products with stock quantity below 100.

• 👤 Total Customers

  DISTINCTCOUNT(salesdb_customers[CustomerID])

  Counts the total number of unique customers.