Forum Discussion

Zaky's avatar
Zaky
Helper IV
5 years ago
Solved

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 ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Zaky 

     

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

    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.

    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.

  • Zaky's avatar
    Zaky
    5 years ago

    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!

Zaky's avatar
Zaky
Helper IV
5 years ago

Dear amitchandak 

 

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

 

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.

 

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Zaky 

 

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

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.

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.

  • Zaky's avatar
    Zaky
    Helper IV
    5 years ago

    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!

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      5 years ago

      Zaky Thank you, glad it was helping 😃

       

      Regards,

      Jing