Average not calculating cumulatively when selecting multiple months (quarter) or fiscal years

Hi,

Please ensure that you have a Calendar table with calculated column formulas for Year, Month name, Month number and Quarter.  Sort the Month name column by the Month number column.  to any visual/filter/slicer, drag any date component from the Calendar table.  Also, assuming qtY_total and ncr_qty are explicit measures which you have written, write this measure and drag it to a card visual

Average = divide([ncr_qty],[qty_total])

Hope this helps.

Hi RadTekno 

I am not sure how your semantic model it setup but you need to tell dax to cumulatively run the average. Perpaps, your formula simply says average which only shows the average of what's been selected. Here's a sample DAX used in the image below.

Cumulative Txn Avg = 
VAR _table =
    FILTER (
        ALL ( Dates ),
        Dates[Date] <= MAX ( Dates[Date] ) && Dates[Year] = MAX ( Dates[Year] )
    )
RETURN
    CALCULATE (
        AVERAGEX ( VALUES ( Dates[Month and Year] ), [Total Transactions] ),
        _table
    )

Please see the attached pbix.