Navigation section

grand total

About this tag
The grand total tag on WindowsForum.com covers discussions about calculating percentages relative to a dynamically filtered total in DAX, particularly using functions like ALLSELECTED. In a thread about sales analysis by type, region, and period, users seek to make each column's percentages sum to 100% based on the current filter context rather than the entire dataset. This involves DAX measures that respect slicer selections for order types, quarters, and regions. The tag is relevant for Power BI and Excel users working with advanced DAX patterns for proportional analysis.
  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