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
    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
    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 !!!!!!!!

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Use Performance Analyzer to get the DAX code for the table when a month is selected in the slicer. Have a look at the code in DAX Studio and you may find that other columns are being filtered on, which you will need to use REMOVEFILTERS on in addition to the year / month column.

Particularly with columns involving months its normal to have a different sort by column, so that they're put into the correct order. This column can be added in to the visuals behind the scenes, and so acts as another filter.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

johnt75 

 

I did that with the overall formula but not the count of months formula.  Let me look at that.  It may help me understand tamerj1 's alternative formula for count of months.