conditional running total based on calculated field value in power bi

[ramutd54]

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 ...

[Abduvali]

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]

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]

@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

[ramutd54]

please check the below two graphs...All REquestsAll open requests

Please refer the above...

[Abduvali]

@ramutd54

I assume that all this data pulled from the same table right.

If so just double check 2 things:

1st check if you haven't turned off filtering interactions on the bottom chart

Click on your filter and go to FORMAT tab in your power bi desktop

and if this all ok then 2nd thing to check your measure or what are using to populate the total count of statuses???

• if its a measure then copy and paste the formula or just screenshot how you getting your total count of statuses. 

Regards

Abduvali

[v-jiascu-msft]

Hi @ramutd54,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards,
Dale

[ramutd54]

the  bottom graph shows only running count for all requests

[ramutd54]

please check the below two graphs...All REquestsAll open requests

Please refer the above...