Cumulative , Average Total in Power BI

summing based on a different column than the default aggregation

Running Total = 
SUMX(
    FILTER(
        ALLSELECTED('Sales'),
        'Sales'[Order Date] <= MAX('Sales'[Order Date])
    ),
    'Sales'[Sales Amount]
)
 

It seems like you're looking to understand how to calculate Cumulative and Average Total in Power BI, which are common tasks in data analysis and reporting. Let's break it down:

1. Cumulative Total in Power BI: This involves calculating a running total of a measure over a specified dimension or time period. You can achieve this using DAX (Data Analysis Expressions), the formula language in Power BI. For example, you can use functions like `CALCULATE` and `FILTER` to sum up values progressively. Here's a simple DAX expression for calculating a cumulative total:

   Cumulative Total = 
   CALCULATE(
       SUM('Table'[Value]),
       FILTER(
           ALL('Table'),
           'Table'[Date] <= MAX('Table'[Date])
       )
   )

2. Average Total in Power BI: This involves calculating the average value of a measure over a particular dimension or time frame. You can use DAX functions like `AVERAGEX` or `SUMX` in combination with `DIVIDE` to calculate the average total. Here's a basic DAX formula for computing the average total:

   Average Total = 
   AVERAGEX(
       'Table',
       'Table'[Value]
   )

Remember, these are simplified examples and the actual implementation may vary based on your data model and requirements. You can customize these expressions further based on your specific needs, such as adding filters, date ranges, or conditional logic.

If you have a specific dataset or scenario in mind, feel free to share more details so that I can provide a more tailored example or explanation.