cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Please help

Hi Experts,

Here I have a challenges:

Appreciated if anyone can help me solve the puzzle.

 

1st challenge is where I want to get the running total the Remaining row.
The Remaining running total should be resulted when the total from the Carry Forward is deducted with the total Accumulative Return.

For example, if I filter Batch return date start from Week 2 of July 2020, the total of the Remaining
is starting 9263 and its getting lesser until the end.

 

Expected result like the table below:

Remaining Table.JPG

 

2nd challenge is where I want to get a weekly performance % for each week.
The performance % should be resulted when the total from Accumulative Return is devide with the total
of Carry forward.

For example, if I filter Batch return date starting from Week 2 of July 2020, the percentage is 4%, week 3 = 2%, week 4 = 1% and so on.

 

Expected result like the table below:

weekly performance.JPG

 

Over the above, the carry forward total is results from the total of Overall (10315) and deducted
with the Previous Returned total (713). 10315-713 = 9602.

 

Btw, the working pbix file is link here  https://1drv.ms/u/s!AqKwe2kf8OBId3mrOrzFnMGPLJE?e=PCD2wa

 

Thanks

2 ACCEPTED SOLUTIONS

Hi @Zaky 

 

Is this what you want? Please download the .pbix file to check more details.

122403.jpg

I created some new measures starting with #M_ in the model. To display the measures on rows, you could go to Format > Values and turn on Show on rows.

122404.jpg

Kindly let me know if this helps.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

View solution in original post

@v-jingzhang ,

 

You are the Master! Exactly as per what i want

Kudos 👍

 

I really appreciated of what you have done, and your effort to made this challenges a successfull.

 

Regards.

I love it!

View solution in original post

5 REPLIES 5
Super User IV
Super User IV

@Zaky , Try like

Remaining row = CALCULATE(COUNTROWS(Data2020),'Data2020'[Status] = "Returned",FILTER(ALLSELECTED(Data2020), 'Data2020'[Batch Return]>=MAX('Data2020'[Batch Return]))) -[#MeasureReturned2020]


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Dear @amitchandak 

 

Thanks for your help. But it is not the result that i want, as the measure has already been created 

 

thepage.JPG

and the measure that I used is

#COUNT SPECIFIC MEASURE CARRY FORWARD =
var a =
CALCULATE(
COUNTROWS('Data2020'), Data2020[Status] IN {"Collected From User","Intransit","Not Process Yet","Not Return By User","Not Yet Return","Pending Collection From User","Redeployed"},
IF(
YEAR('Data2020'[Batch Return])=2019 || YEAR('Data2020'[Batch Return])=BLANK(),1,0)
)

var b=
CALCULATE(
COUNTROWS('Data2020'),
FILTER(
Data2020,
((Data2020[Batch Return].[MonthNo])=3||(Data2020[Batch Return].[MonthNo])=4||(Data2020[Batch Return].[MonthNo])=5||(Data2020[Batch Return].[MonthNo])=6||(Data2020[Batch Return].[MonthNo])=7||(Data2020[Batch Return].[MonthNo])=8||(Data2020[Batch Return].[MonthNo])=9||(Data2020[Batch Return].[MonthNo])=10||(Data2020[Batch Return].[MonthNo])=11||(Data2020[Batch Return].[MonthNo])=12)&&YEAR(Data2020[Batch Return])=2020)
)
return
a+b

 

 

Thanks.

 

Hi @Zaky 

 

Is this what you want? Please download the .pbix file to check more details.

122403.jpg

I created some new measures starting with #M_ in the model. To display the measures on rows, you could go to Format > Values and turn on Show on rows.

122404.jpg

Kindly let me know if this helps.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

View solution in original post

@v-jingzhang ,

 

You are the Master! Exactly as per what i want

Kudos 👍

 

I really appreciated of what you have done, and your effort to made this challenges a successfull.

 

Regards.

I love it!

View solution in original post

@Zaky Thank you, glad it was helping 😃

 

Regards,

Jing

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors