Forum Discussion
Nimai123
Post Patron
Post PatronRunning total/Cumulative sum
I have created a measure 1 and I want to create a running total measure depending upon the measure 1, I have been through many blogs and links on the internet but not able to get the desired output ...
Nimai123 , Try like
Running Open Stragglers Low Risk = Var a = MINX(ALLSELECTED(Qtr),Qtr[Week Num]) Return CALCULATE(Sum(bookings_reporting_view[line_item_acv_price_converted]), FILTER(ALLSELECTED(bookings_reporting_view), bookings_reporting_view[med_fq_Qtr Name] < MIN(Qtr[Qtr Name])&& bookings_reporting_view[cld_weekhelp] <= MIN(Qtr[Week Num])&& bookings_reporting_view[cld_weekhelp] >= a && OR(bookings_reporting_view[stage] in {"1 - Discover Opportunity","1 - Renewal Opportunity","2 - Renewal Initiated","3 - Renewal Low Risk","2 - Qualify Opportunity","3 - Validate Solution"}, bookings_reporting_view[stage] in {"4 - Renewal Procurement","5 - Manage Procurement"}) && bookings_reporting_view[isclosed] = {"0"}))Nimai123 ,
Try below measure to get your expected result:
Running Stragglers Low Risk=Var Res = CALCULATE(sum(bookings_reporting_view[line_item_acv_price_converted]),FILTER(ALLSELECTED(bookings_reporting_view),bookings_reporting_view[med_fq_Qtr Name] < MIN(Qtr[Qtr Name]) &&bookings_reporting_view[cld_weekhelp] <=MIN(Qtr[Week Num]) &&bookings_reporting_view[cld_weekhelp] >= (CALCULATE(MIN(Qtr[Week Num]),FILTER(ALLSELECTED(Qtr),Qtr[Week Num]<=MIN(Qtr[Week Num]))))&& bookings_reporting_view[stage] in {"1 - Discover Opportunity","1 - Renewal Opportunity","2 - Renewal Initiated","3 - Renewal Low Risk","2 - Qualify Opportunity","3 - Validate Solution" } &&bookings_reporting_view[isclosed] = {"0"}))RETURN Res
amitchandak
Super User
Super UserNimai123 , Try like
Running Open Stragglers Low Risk =
Var a = MINX(ALLSELECTED(Qtr),Qtr[Week Num])
Return
CALCULATE(Sum(bookings_reporting_view[line_item_acv_price_converted]),
FILTER(ALLSELECTED(bookings_reporting_view),
bookings_reporting_view[med_fq_Qtr Name] < MIN(Qtr[Qtr Name])&&
bookings_reporting_view[cld_weekhelp] <= MIN(Qtr[Week Num])&&
bookings_reporting_view[cld_weekhelp] >= a &&
OR(bookings_reporting_view[stage] in {"1 - Discover Opportunity","1 - Renewal Opportunity","2 - Renewal Initiated","3 - Renewal Low Risk","2 - Qualify Opportunity","3 - Validate Solution"}, bookings_reporting_view[stage] in {"4 - Renewal Procurement","5 - Manage Procurement"})
&& bookings_reporting_view[isclosed] = {"0"}))
Tahreem24Super User
Super UserNimai123 ,
Try below measure to get your expected result:
Running Stragglers Low Risk=
Var Res = CALCULATE(sum(bookings_reporting_view[line_item_acv_price_converted]),
FILTER(ALLSELECTED(bookings_reporting_view),
bookings_reporting_view[med_fq_Qtr Name] < MIN(Qtr[Qtr Name]) &&
bookings_reporting_view[cld_weekhelp] <=MIN(Qtr[Week Num]) &&
bookings_reporting_view[cld_weekhelp] >= (CALCULATE(MIN(Qtr[Week Num]),FILTER(ALLSELECTED(Qtr),Qtr[Week Num]<=MIN(Qtr[Week Num]))))
&& bookings_reporting_view[stage] in {"1 - Discover Opportunity","1 - Renewal Opportunity","2 - Renewal Initiated","3 - Renewal Low Risk","2 - Qualify Opportunity","3 - Validate Solution" } &&
bookings_reporting_view[isclosed] = {"0"}))
RETURN Res