Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter All Loses Slicer Capability

I am displaying a table below on my report:   The rows are measures calculated from Table T1. The measure used to calculate the bottom row is:   CALCULATE(sum(T1[Count]), FILTER(         ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    The answer is to use ALLEXCEPT in place of ALL. Here was the final query that I used.

     

    CALCULATE(sum(T1[Count]), FILTER(
                        ALLEXCEPT(T1,T1[userid],T1[username]),T1[dateend] >= SELECTEDVALUE('Date'[WeekEndDate]) - 6
                                     && T1[dateend] <= SELECTEDVALUE('Date'[WeekEndDate]))
                    )
     
Anonymous's avatar
Anonymous
Not applicable
3 years ago

The answer is to use ALLEXCEPT in place of ALL. Here was the final query that I used.

 

CALCULATE(sum(T1[Count]), FILTER(
                    ALLEXCEPT(T1,T1[userid],T1[username]),T1[dateend] >= SELECTEDVALUE('Date'[WeekEndDate]) - 6
                                 && T1[dateend] <= SELECTEDVALUE('Date'[WeekEndDate]))
                )