Forum Discussion

Zaky's avatar
Zaky
Icon for Helper IV rankHelper 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!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Zaky , Try like 

Remaining row = CALCULATE(COUNTROWS(Data2020),'Data2020'[Status] = "Returned",FILTER(ALLSELECTED(Data2020), 'Data2020'[Batch Return]>=MAX('Data2020'[Batch Return]))) -[#MeasureReturned2020]
Zaky's avatar
Zaky
Icon for Helper IV rankHelper 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
    Icon for Community Support rankCommunity 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
      Icon for Helper IV rankHelper 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
        Icon for Community Support rankCommunity Support
        5 years ago

        Zaky Thank you, glad it was helping 😃

         

        Regards,

        Jing