Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Not really sure how to explain this but here goes.
I have a calculation which sums up the number of non-automated jobs:
Sum({<[Failure Code-reason]-={'Success'}>}[jobs])
I can calculate the percentage of non-automated jobs with the following:
Sum({<[Failure Code-reason]-={'Success'}>}[jobs])
/
(Sum({1<[Failure Code-reason]-={'Success'}>}[jobs]))
I want to be able to calculate these for a where a user is interacting with a lot of filters except where a user selects a time dimension called [Mon].
The purpose of this is to always calculate percent of failures over the selected time period.
I can't figure out a way to evaluate the above based on the [Mon] selection
Any ideas?
By simplifying the problem I was able to figure this one out through searching the forums.
The following formula works for my purpose:
(Sum({<[Mon]=P([Mon])>*<[Failure Code-reason]-={'Success'}>}[jobs]))
/
(sum({1<[Mon]=P([Mon])>*1<[Failure Code-reason]-={'Success'}>} TOTAL [jobs]))
Cheers,
Thomas
Call that into the expression, as follows
Sum({<[Failure Code-reason]-={'Success'}, Time-={'Mon'}>}[jobs])
/
(Sum({1<[Failure Code-reason]-={'Success'}, Time-={'Mon'}>}[jobs]))
Thanks for your response Saminea, but it isn't working for me.
Expected result is where a filter on only [Mon], the value should stay as 1 (100%) because it reflects 100% of the jobs for the [Mon]
When filtered on any other dimension e.g. [Client], [Stream] etc. it should then break down to a value less than 1 based on the % of failure jobs for teh selected [Mon] (or multiple).
Where I select one more multiple [Mon], your formula like mine is still evaluating the percentage of total i.e. 0.07 (7%)
Any ideas?
Still stuck on this one. I think the issue here is the denominator.
(Sum({1<[Failure Code-reason]-={'Success'}, Time-={'Mon'}>}[jobs]))
The formula will work if I can get this to:
I suspect this isn't too hard and I'm just missing something!
By simplifying the problem I was able to figure this one out through searching the forums.
The following formula works for my purpose:
(Sum({<[Mon]=P([Mon])>*<[Failure Code-reason]-={'Success'}>}[jobs]))
/
(sum({1<[Mon]=P([Mon])>*1<[Failure Code-reason]-={'Success'}>} TOTAL [jobs]))
Cheers,
Thomas