Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Can't remove filter from visual

Hello everyone, first post here   I created a graph that shows the value of a KPI for every shift (A, B, C) for the last 7 days. It works as expected in its own page. However I tried to use it as a...
Need Help
  • suparnababu8's avatar
    suparnababu8
    1 year ago

    Hi Anonymous 

    Try this 

    VALUE =CALCULATE(MAX(DATA[VALUE]),FILTER(ALL(DATA),
        DATA[Date] >= TODAY() - 7 && DATA[Date] <= TODAY())
)
suparnababu8's avatar
suparnababu8
Super User
1 year ago

Hi Anonymous 

Try this 

VALUE =CALCULATE(MAX(DATA[VALUE]),FILTER(ALL(DATA),
        DATA[Date] >= TODAY() - 7 && DATA[Date] <= TODAY())
)