Cumulative Sum with crossfilters

[Lewa]

Hi all! 

I need your help again.

So, 

Measure = 
VAR FILTER2 = FILTER(ALL(Calendary) ; Calendary[Date] <= MAX(Calendary[Date])) 
VAR FILTER1 = FILTER(ALLSELECTED(Transactions) ; TRUE());
RETURN 
       CALCULATE ( 
                  CALCULATE(SUM(Transactions[Cost]) ; 
                  FILTER2 
       ) ; 
       FILTER1 
)

Im using for cumulative sum FILTER2, but it's not working -- why? 

[danextian]

Hi @Lewa,

There is a Quick Measure feature in Power BI Desktop which can be accessed from the ellipsis that appears when you hover a measure. It can generate a DAX formula similar to below:

CALCULATE (
    SUM( 'PMBudgetMonitor'[Cost] ),
    FILTER (
        ALLSELECTED ( 'Dates'[Date] ),
        ISONORAFTER ( 'Dates'[Date], MAX ( 'Dates'[Date] ), DESC )
    )
)

Also, a well-structured question with sample data and expected output can get a better response and possibly a faster resolution.  

[Ashish_Mathur]

Hi,

Please explain the question.  Share a dataset and show the expected result.

[Lewa]

@Ashish_Mathur Hi, 

share -- sample pbix, where: 

FILTER1 = required filter

FILTER2 = cumulative filter

Problem is: 

without FILTER1 its work correct, 

with -- nope. 

[Ashish_Mathur]

Hi,

I still do not understand the question.  Please explain the business question and show your expected result.

[Lewa]

@Ashish_Mathur

share -- sample pbix, where: 

filter1 = required filter

filter2 = cumulative sum

without filter1 its work correct, with -- nope <its problem!>.