Forum Discussion
Filter Measure Between Dates
- Anonymous6 years ago
I managed to created a count measure that works as I would like;
Count of Active =VAR __SelectedDate = [Selected Date]ReturnCALCULATE(COUNT('Risk Data'[Id]),__SelectedDate>'Risk Data'[FromTT], IF(ISBLANK('Risk Data'[ToTT]), TRUE(), __SelectedDate<'Risk Data'[ToTT]))
But I'm not sure how'd I go about turning this into a true/false filter measure of each risk ID - 6 years ago
hi Anonymous
Anonymous wrote:
I managed to created a count measure that works as I would like;
Count of Active =VAR __SelectedDate = [Selected Date]ReturnCALCULATE(COUNT('Risk Data'[Id]),__SelectedDate>'Risk Data'[FromTT], IF(ISBLANK('Risk Data'[ToTT]), TRUE(), __SelectedDate<'Risk Data'[ToTT]))
But I'm not sure how'd I go about turning this into a true/false filter measure of each risk IDI have test on my side, This formula works well, and what is " I'm not sure how'd I go about turning this into a true/false filter measure of each risk ID"?
Regards,
Lin
- Anonymous6 years ago
Ah sorry, I've just realized if I use my count of acting as the visual level filter, I just need to set it to is greater than 0 to get the effect I was looking for.
The previous response about setting the filter to true was confusing me since it wasn't an IF measure.
A lot of them seem to be history tables... are they all histories of the same event ?
The Data is for BowTie Reporting. We have different hazards at our company, i.e. Vehicle accidents. Each of these hazards have different threats and consequences, example threats being crash as the result of employee intoxication, or crash as a result of third-party error. Different consequences being cost of destroyed vehicles, physical injury, loss of life. These threats and consequences have controls to mitigate these risks, such as license checks to take out company cars, sobriety checks, insurance to mitigate financial loss. All of these have different levels of severity and likelihood allocated to them, such as a crash resulting in loss of life being high severity and low likely hood, or a fender bender being moderate likelihood, low severity. These likelihoods are determined by the efficacy of the controls to prevent them such as the sobriety check and license reducing the likelihood of occurrence, so when new check are added in, likelihoods change, or if we implement more effective controls. I want to be able to see the number of risks over time, how effectively we've been covering them etc.
- Anonymous6 years agoNot applicable
So there is a table for hazards, table for risk, one for consequneces, one for controls for risks and one for consequnece etc.
Thus each table has dates for when new risks are added and removed, when we've implemented controls for those risks, how serverity and likelihoods change over time, and whatnot
- Anonymous6 years agoNot applicableI have checked the conversation...the measure you have create is correct. Just add that measure to visual level filter and set it to TRUE.
If facing difficulties then replace those true false with 1 0 in measure and add set visual level filter to 1.
Thanks
Pravin
If it resolves your problem mark it as a solution and give Kudos. - Anonymous6 years agoNot applicable
Could you show me which measure is the correct one? I'm not too sure which one you mean.