Navigation section

dax

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. 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
Back
Top