Forum Discussion

ramutd54's avatar
ramutd54
Icon for Advocate I rankAdvocate I
8 years ago

conditional running total based on calculated field value in power bi

I am new to power bi and i am facing one issue  on running total..

 

Here  source is like this

 

open_Date, reqest no, status

2017-jan-01,1010345, closed

2017-jan-01,1014234, closed

2017-jan-01,1033245,open

2017-jan-04,2035432,rejected

2017-jan-04,2010345, closed

2017-jan-04,3014234, closed

2017-jan-04,3033245,open

2017-jan-05,6035432,rejected

2017-jan-05,6010345, closed

2017-jan-05,6014234, closed

2017-jan-05,6033245,open

2017-jan-05,6035432,rejected

 

My rquirement is find the running sum for all issues based on the  issue status...

i i click the status "OPEN" then the same graph should show the "open " issues running sum. same for remaing status ...

 

Please help me how to do this ...

Need Help

8 Replies

  • Abduvali's avatar
    Abduvali
    Icon for Skilled Sharer rankSkilled Sharer
    8 years ago

    Hi ramutd54,

     

    When you say running total of the SUM, can you tell me what are you trying to SUM???

    • Because in a data sample you provided there are only: Date, Req no, and a Status

     

    Regards

    Abduvali

     

     

    • ramutd54's avatar
      ramutd54
      Icon for Advocate I rankAdvocate I
      8 years ago

      Hi Thank you..

       

      I have a requirement to  filter the entire dashboard based on  request status. 

       

      i have proivded only request no, open date and status.

       

      i have to filter the  running total SUM using the "request status".

       

      i have tacken  the status in normal slicer or ChicletSlicer. based on the selection of the status the running total graph should be changed. for example the total running SUM of all issues is 120 by default it shows the graph up to 120 or all open dates.

       

      if i click the  "OPEN" status then it will display the  running total sum 24 like that for all  respective open dates...

      • Abduvali's avatar
        Abduvali
        Icon for Skilled Sharer rankSkilled Sharer
        8 years ago

        ramutd54

         

        If I understood you correctly you just need to use a slicer for it:

        Select Slicer from visualisations and drop your Status field in it:

        Select your Status to filter your table

         

         

        Is this what you were looking for?

         

         

        Regards

        Abduvali