Cumulative value of a measure based on date slicer value

[Anonymous]

Hi there,

I am using the following measure to equally distribute a value between a project's start and end date:

distributed_results = CALCULATE(SUMX(FILTER(Projects,Projects[begin]<=max(Calendar[Date]) && Projects[end]>=MIN(Calendar[Date])),(Projects[distributed_value])),CROSSFILTER(Projects[begin],Calendar[Date],None))

The filtering is based on the year value of a date slicer.

Now,  I would like to display a cumulative value in the graph for this exact calculation. So far, I've tried the following:

cumulative = calculate([distributed_results],FILTER(all(Calendar[Date].[Year])Calendar[Date].[Year]>=SELECTEDVALUE(Calendar[Date].[Year])),FILTER(all(Calendar[Date]), Calendar[Date] <= max(Calendar[Date])))

However, I do get the wrong values and I do not know where they come from.

How can I get the cumulative value for the first measure based on the value of my date slicer?

Thank you very much for your help!

[amitchandak]

@Anonymous , refer if the attached after signature can help

[Anonymous]

@amitchandak Thanks for the file. Unfortunately not the thing, I was looking for.

I used the measure I mentioned to distribute values between a start and an end date (as you did in the file). Now, I need a monthly running total based on that measure. This should also be based on the year selected in a date slicer.

I hope you get what I'd like to accomplish.

[Anonymous]

HI @Anonymous,

I'd like to recommend you to take a look at below blog if its scenarios meet your requirement:

Before You Post, Read This  

Regards,

Xiaoxin Sheng

[Anonymous]

@Anonymous Thanks for the message. I've had a look at it before I posted but nothing really helps in my case.

I made a simplified pbix file so that you can see what I am trying to achieve. Since I think that I am not able to post it on here, I uploaded the file to https://we.tl/t-dPScxy8xA2

I do have a measure that displays a certain value between the start and end date of a project. Now, I need a monthly running total but all I get is the following:

 Instead, e.g. February should show 90 and March 170 for the running total (right column).

Could someone please have a look at the code? I would highly appreciate your help.

Maybe @amitchandak could help me with that as well.

[amitchandak]

@Anonymous , file is empty

[Anonymous]

@amitchandak Sorry, please use

https://we.tl/t-mMKqD22lbM

[Anonymous]

@amitchandak Unfortunately, I cannot see any attachments. Could you send it again, please? Thank you!

[amitchandak]

Check now