DAX Single Value Measure

Modified on Sun, 26 Jul at 4:38 AM

Overview

Single Value Measures include calculations that do not follow a calendar pattern and are not divided into specific calendar buckets.

This category includes several types of measures:

  • Benchmark
  • KPI
  • Count
  • Attribute

Measure 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

Expected Result

Single Value Measures provide ready-to-use benchmarks, KPIs, counts, and attributes for business questions that do not fit a repeating calendar pattern or a specific calendar-period calculation.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article