Return table with ignoring some filters in DAX

[wvadik]

I have table

Table1(Field1, Field2, Field3, Field4, Field5)

and in SUMMARIZE function I need put Table1 with columns Field1, Field2, Field3 and ignoring any filters on columns Field4, Field5.

I can't just do this:

SUMX(
  SUMMARIZE(
     ALLEXCEPT(Table1, Table1[Field1], Table1[Field2], Table1[Field3]),
     Table1[Field1], 
     Table1[Field2], 
     Table1[Field3]
  ), 
  Field3
)

[amitchandak · Accepted solution]

@wvadik , Try like

SUMX(
SUMMARIZE(
calculateTable(Table1, all(Table1[Field4]), all(Table1[Field5])),
Table1[Field1],
Table1[Field2],
Table1[Field3]
),
Field3
)

or 

SUMX(
SUMMARIZE(
calculateTable(Table1, removefilters(Table1[Field4]), removefilters(Table1[Field5])),
Table1[Field1],
Table1[Field2],
Table1[Field3]
),
Field3
)