Forum Discussion
Filter Measure Between Dates
I have data which has a from and to date, with the date it is created in the from and the date its no longer active in the to column. I created a filter measure so I can selected a date from a discon...
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 IDhi 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
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.
I 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.
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.
Could you show me which measure is the correct one? I'm not too sure which one you mean.