Forum Discussion
Auto filtering based on values provided
Hi. I have a problem with a line chart. I want to automatically filter time based on values provided by sensors. For example: Sensors provided values since 14:30 to 21:30 at 21st October 2023 and ...
I tried something like this, but it filters the sensor values and i only want to apply the shift value as a filter
CALCULATE(VALUES('table'[Licznik cefla_1]),FILTER(FILTER('table','table'[sensor1] > 0),'table'[shift]))
That code makes little sense. Can you describe, in business terms, what you are trying to achieve? Maybe even show the expected outcome?