Forum Discussion
Helper ICumulative and blank
I'm trying to solve a problem with cumulative and blank result.
I've created a measure and it is working ok but when I change the context and I have some blank between the result it doesn't work properly.
Planned Value BAC = SUM(Budget[budget_rev])
BAC cummulative new = CALCULATE([Planned Value BAC],FILTER(ALLSELECTED(Budget),Budget[account_period] <= MAX(Budget[account_period])))
2 Replies
- Greg_Deckler
Community Champion
Can you provide that sample data as something that can be copied and pasted?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
v-jiascu-msftMicrosoft Employee
Hi ftorres,
This one is similar to Cummulative-with-measure-not-working, isn't it? Can you please share a sample?
Best Regards,
Dale
