Docs
  • Docs
  • Tcdx
    • Tcdx command line tool
    • Tcdx serialization
    • The Tcdx Object Model
      • Consumer
      • QueryGroup
      • Item
      • ModelDependency
      • TableDependency
      • ColumnDependency
      • MeasureDependency
      • VersionInfo
      • ConsumersCollection
      • QueryGroupsCollection
  • Bravo for Power BI
    • Installation
    • User Interface
    • How To Connect
    • Features
      • Analyze Model
      • Format DAX
      • Manage Dates
        • Customize Date Templates
        • Template Editor
        • Deploy Organization Template
      • Export Data
    • Configuration
      • Options
      • Registry
  • Contoso Data Generator
    • Details
    • Output formats
    • Scripts
    • Configuration file
    • Configuration data
    • LakeHouse
    • SQL Scripts
  • DAX Internals
    • Optimization notes
      • Vertical Fusion
      • Horizontal Fusion
      • IsAvailableInMDX Property
      • SWITCH optimization
    • VertiPaq internals
      • Logical Query Plan in VertiPaq
      • Physical Query Plan in VertiPaq
      • xmSQL code in VertiPaq
  • Dax Template
    • Calendar templates
      • Standard calendar
      • Monthly calendar
      • Weekly calendar
      • Custom calendar
    • Configuration
      • Annotations
      • Config object
        • Custom Table
        • Date Template
        • Holidays
        • Localization
        • Measure Template
        • Scan
        • Templates
      • Dax Placeholders
      • Configuration
        • HolidaysDefinition
        • Language
        • Translation.Definition
    • Templates
      • Custom Date Table
      • Custom Template Table
      • Holidays Definition Table
      • Holidays Table
      • Measures Template
  • VertiPaq Analyzer
    • VPAX command line tool
    • Excel metrics
      • Column Segment
      • Column
      • Relationship
      • Table
      • User Hierarchy
  • SQLBI API
    • Licensing
      • Me
      • Courses
      • Pools
      • Licenses
      • Students
  • SQLBI Services
    • Licensing
    • License Manager
  • Terms & Conditions
    • Classroom Courses
    • Video Courses
    • Transferable Licenses
    • SQLBI+ Subscription
    • Remote Consulting
    • Additional services
    • Payments and Security
    • Privacy Policy
    • Third-Party Licenses
Docs  \  DAX Internals  \ 

Optimization notes

Available optimization notes:

  • Vertical Fusion
  • Horizontal Fusion
  • IsAvailableInMDX Property
  • SWITCH optimization
Last update: Apr 07, 2025
Copyright © SQLBI Corp. • www.sqlbi.com  |  Privacy Policy  |  Terms of Use  |  Contact Us