Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wvadik
Helper III
Helper III

Devolver la tabla ignorando algunos filtros en DAX

Tengo mesa

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

y en la función SUMMARIZE necesito poner Table1 con las columnas Field1, Field2, Field3 e ignorar los filtros en las columnas Field4, Field5.

No puedo hacer esto:

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@wvadik , Probar como

SUMX(
RESUMEN(
calculateTable(Table1, all(Table1[Field4]), all(Table1[Field5])),
Tabla 1[Campo1],
Tabla 1[Campo2],
Tabla 1[Campo3]
),
Campo3
)

O

SUMX(
RESUMEN(
calculateTable(Table1, removefilters(Table1[Field4]), removefilters(Table1[Field5])),
Tabla 1[Campo1],
Tabla 1[Campo2],
Tabla 1[Campo3]
),
Campo3
)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@wvadik , Probar como

SUMX(
RESUMEN(
calculateTable(Table1, all(Table1[Field4]), all(Table1[Field5])),
Tabla 1[Campo1],
Tabla 1[Campo2],
Tabla 1[Campo3]
),
Campo3
)

O

SUMX(
RESUMEN(
calculateTable(Table1, removefilters(Table1[Field4]), removefilters(Table1[Field5])),
Tabla 1[Campo1],
Tabla 1[Campo2],
Tabla 1[Campo3]
),
Campo3
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors