Forum Discussion

glaso-is's avatar
glaso-is
Frequent Visitor
8 years ago

DAX: Cumulative Total Applying filters

Hi,   I was trying to get the cumulative total from a filtered dataset selecting some years in the slicer, but I'm always obtaining the cumulative from the whole dataset only for the selected years...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Is "Total" a column in your example a column? The default SUM aggregation of the column will work in your case for the data you provided. 

popov's avatar
popov
Icon for Resolver III rankResolver III
8 years ago

Hi, glaso-is
If I correct understud, you need to use ALLSELECTED() function, something like this:

Cumulative Total Applying filters :=
CALCULATE (
    [Total Sales];
    FILTER (
        ALLSELECTED ( 'Calendar' );
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
    )
)