DAX Single Value Measure

Overview

This category includes a potpourri of measures which don't follow a calendar pattern, nor are segmented into specific calendar buckets.

This includes:

• Benchmark
• KPI
• Count
• Attribute

Compendium

Customer

• Average Sales Amount
• Average Sales Quantity
• Days Since Last Purchase
• First and Last Transaction Amount
• First and Last Transaction Date
• Lifetime Value
• Sales Transaction Count
• Customer Count (This is also used in Calendar Specific Measures)

Vendor

• Average Purchase Amount
• Average Purchase Quantity
• Days Since Last Purchase
• Last Purchase Transaction Amount
• Last Purchase Transaction Date
• Purchase Transaction Count

Item

• Item Count (All)
• Item Count (Assemblies)

Inventory

• Days out of Stock
• Days out of Stock (Last 30 Days)
• Days Sales [DSI]
• Fulfillment Rate (Last 30 Days)
• Fulfillment Rate (Last 365 Days)
• Gross Margin on Investment [GMROI]
• Quantity on Hand (Cumulative)
• Quantity on Hand (Today)
• Retail Value
• Turnover Ratio
• Valuation (30 Days Ago)
• Valuation (365 Days Ago)
• Valuation (Today)
• Inventory to Sales Ratio [I/S] (Last 30 Days)
• Inventory to Sales Ratio [I/S] (Last 365` Days)

Job Cost (Job Cost Details)

• Committed %
• Committed Remaining
• Committed vs Actual
• Completion %
• Cost to Complete
• Earned Revenue to Date
• Estimate vs Actual
• Estimate vs Committed
• Estimated Profit
• Estimated Profit %
• Income to Date
• Over-Under Billing
• Profit % at End
• Profit to Date
• Remaining Contract

Job (Pand L by Job and by Class)

• Job Actual
• Job Actual % Sales
• Job Budget
• Job Budget % Sales

Balance Sheet

• Current Ratio
• Working Capital

Fixed Assets

• Percent Depreciated

Audit Trail

• Document Data Entry - Modified
• Document Data Entry - New
• Document Data Entry - Combined