Forum Discussion

NorbertG's avatar
NorbertG
Icon for Helper I rankHelper I
2 years ago

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 ...
NorbertG's avatar
NorbertG
Icon for Helper I rankHelper I
2 years ago

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]))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That code makes little sense.  Can you describe, in business terms, what you are trying to achieve?  Maybe even show the expected outcome?