Calculate Monthly based Cumulative Percentage

[Anonymous]

Hi,
I'm able to caculate Monthly Cumulative for Number measure..

And same Monthly cumulative logic I want to peform for the Calculated Percentage measure...

I tried to wite same formula but records are not coming as expected !!
Put your thoughts & Suggestion !!
Thanks in advance. 
@DAXUser 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.
Measure:

Cumulative target = SUMX(FILTER(ALL(KM),[Calendar Day]<=SELECTEDVALUE(KM[Calendar Day])),[Target%])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MeetPatel · Accepted solution]

Hi @Anonymous

Here,

new measure name = C Target Shipment %
Table Name = KM

Based on cumulative total = Target Shipment %

C Target Shipment % = CALCULATE(SUMX(VALUES(KM),[Target Shipment %]),FILTER(ALLSELECTED(KM),KM[Calendar Day].[Day]<=MAX(KM[Calendar Day].[Day])))

 If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Meet Patel

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.
Measure:

Cumulative target = SUMX(FILTER(ALL(KM),[Calendar Day]<=SELECTEDVALUE(KM[Calendar Day])),[Target%])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.