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
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] )
    )
)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you!!!