Forum Discussion
Running Total Struggles
Hi all, I am new to PowerBI and this is the first issue I have not been able to resolve by searching through previous posts. I have a list of fault tickets with opened and closed dates. There...
Hi, thanks for the reply.
I haven't been able to make any of these commands work.
I think the problem I am having is the way I have calculated the tables.
The Files Raised column is:
Count Open = COUNT('Failure Table'[Failure Number])
Failure numbers being a string.
The files closed column is:
Count Closed = CALCULATE(COUNT('Failure Table'[Failure Number]), USERELATIONSHIP('Calendar'[Date], 'Failure Table'[Date of Engineer Sign-Off]))
'Files still open' is just a quick measure with "Count Open = COUNT('Failure Table'[Failure Number])" with a filter on for blank sign-off date.
The 'Running total' (which doesn't work) column is:
Running Total (Failure) =
CALCULATE(
COUNT('Failure Table'[Failure Number]),
FILTER(
ALLSELECTED('Failure Table'[Financial Period]),
ISONORAFTER('Failure Table'[Financial Period], MAX('Failure Table'[Financial Period]), DESC)
)
)
Any chance you can provide a sample dataset or PBIX file?
Unfortunately the data is sensitive and I do not know a way to provide a sample set. I'm still very new to this.