Forum Discussion

eaglesilo's avatar
eaglesilo
Frequent Visitor
3 years ago

DAX RemoveFilters issue --SOLVED

I am trying to get a RemoveFilters function to work.  Basically, I want to get a Count of ID in QtData for a specific EquipmentGroup and TimePeriod that ignores any Slicers that impact the Visual ...
Need Help
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

eaglesilo Let's say that Type1 and Type2 have ID's of 1 and 2, you could do this:

M_6MonthQtCt_Type1-Type2 = 
  VAR __Table = FILTER( ALL( 'QtData'), EquipmentTypeId IN { 1, 2 } && [qtDate] >= [M_6MonthsPrev])
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result

If later you want to do a SUM, then you could replace COUNTROWS with SUMX.

eaglesilo's avatar
eaglesilo
Frequent Visitor
3 years ago

Ended up with the below as the solution:

M_6MonthQtCt_Type1-Type2 = 
CALCULATE ( COUNT ( QtData[Id] )
    , ALL(DateRangePicker) 
    , FILTER ( ALL ( 'QtData' )
    , QtData[qtDate] >= 'Calendar'[M_6MonthsPrev] ) 
    , EquipmentSelect[TypeGrouping] IN { "Type1", "Type2" } 
)

 

I think your solution would have worked, but EquipmentType.TypeGrouping contains many TypeIDs and this allows for the IDs in the group to change server side and flow through to PBI.  (The EquipmentSelect table is pulled directly from SQL and managed and updated within there)