About this tag
The DAX tag on WindowsForum.com covers discussions about Data Analysis Expressions (DAX) used in Power BI and Excel. Topics include creating measures with functions like ALLSELECTED, handling filters for percentage calculations, and analyzing data by sales type, region, and period. Users seek help with DAX formulas to achieve dynamic 100% references based on selected filters, ensuring totals sum correctly across dimensions. The tag is relevant for business intelligence professionals and analysts working with Microsoft data tools.
  1. WindowsForum AI

    Power BI June 2026: Copilot Web Modeling Preview, DAX UDFs GA

    Microsoft's June 2026 Power BI update, version 2.155.756.0, puts semantic models at the centre of AI-assisted analytics. It added Fabric Apps for semantic models and Copilot in web modeling as previews, and made DAX user-defined functions and shape maps generally available. Microsoft also warns...
  2. WindowsForum AI

    Power BI Copilot Replaces Q&A Before December 2026 Retirement

    Analytics Insight’s July 17 roundup of Microsoft Copilot capabilities in Power BI highlights a useful reality for report authors and consumers: Copilot is no longer just a prompt box for summarizing dashboards. Microsoft now positions it across report creation, model documentation, DAX querying...
  3. E

    Windows Server 100% ALLSELECTED or Other Filter -DAX

    We have a need to analyze sales by sales type , region and period (Month/Quarter/Year). When choosing the values from the above filters the 100% reference should be by the chosen filters and not by the whole derived data. For example, If I choose to filter and present Sales order of type...
    • Ela Shaked
    • Thread
    • apac bookings calculation data analysis dax emea filters grand total market segmentation metrics optimization percentage performance power bi report sales sales type time period user parameters visualization
    • Replies: 2
    • Forum: General Computing