Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

RemoveFilters is not working

Hi.  Yet another post about removefilters not working but none of the other answers have helped.  Please, please help me resolve.   Summary: I am trying to create a clustered table that contains: ...
all
REMOVEFILTERS
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
I may suggest 

 

_Inc SC Avg Count by W# =
DIVIDE (
    AVERAGEX (
        VALUES ( 'DATE Table'[_Date SC Week of Month (# only)] ),
        CALCULATE (
            [_Inc Count],
            ALLEXCEPT ( 'DATE Table', 'DATE Table'[_Date SC Week of Month (Week Name] )
        )
    ),
    CALCULATE (
        DATEDIFF ( MIN ( INCIDENTS[Date] ), MAX ( INCIDENTS[Date] ), MONTH ),
        ALLEXCEPT ( 'DATE Table', 'DATE Table'[_Date SC Week of Month (Week Name)] )
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Tamerj1 is so beyond awesome, it's amazing.  Never gave up...stayed with it for DAYS and HOORAY!!!!!  FOUND THE SOLUTION.

 

THANK YOU tamerj1 !!!!!!!!