cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ramutd54 Frequent Visitor
Frequent Visitor

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

power bi  running total.JPG

8 REPLIES 8
Abduvali Established Member
Established Member

Re: conditional running total based on calculated field value in power bi

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 Frequent Visitor
Frequent Visitor

Re: conditional running total based on calculated field value in power bi

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 Established Member
Established Member

Re: conditional running total based on calculated field value in power bi

@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:

Capture39.PNGSelect your Status to filter your table

 

 

Is this what you were looking for?

 

 

Regards

Abduvali

 

 

ramutd54 Frequent Visitor
Frequent Visitor

Re: conditional running total based on calculated field value in power bi

please check the below two graphs...complaints  summary1.jpgAll REquestscomplaints  summary2.jpgAll open requests

 

Please refer the above...

ramutd54 Frequent Visitor
Frequent Visitor

Re: conditional running total based on calculated field value in power bi

please check the below two graphs...complaints  summary1.jpgAll REquestscomplaints  summary2.jpgAll open requests

 

Please refer the above...

ramutd54 Frequent Visitor
Frequent Visitor

Re: conditional running total based on calculated field value in power bi

the  bottom graph shows only running count for all requests

Highlighted
Abduvali Established Member
Established Member

Re: conditional running total based on calculated field value in power bi

@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

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

Community Support Team
Community Support Team

Re: conditional running total based on calculated field value in power bi

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.