CALCULATE(): CALCULATE( SUM( Sales ), Year = 2025 ) : Modify filter context for measure

CALCULATETABLE(): CALCULATETABLE( Orders, Orders[Status]="Pending" ) : Return table with new
filters

FILTER(): FILTER( Orders, Orders[Sales]>1000 ) : Row-by-row filter returning table

ALL(): ALL( Orders ) : Remove filters from specified table

ALLEXCEPT(): ALLEXCEPT( Orders, Orders[Region] ) : Clear filters except listed columns

ALLSELECTED(): ALLSELECTED( Orders ) : Respect report/page/visual selections

REMOVEFILTERS(): REMOVEFILTERS( Orders[Segment] ) : Explicitly clear filters

KEEPFILTERS(): KEEPFILTERS( Orders, Orders[Region]="East" ) : Add filter without overwriting
existing

USERELATIONSHIP(): CALCULATE( SUM( Sales ), USERELATIONSHIP(Date[Date],ShipDates[Date]) ) :
Activate inactive relationship

CROSSFILTER(): CALCULATE( SUM( Sales ), CROSSFILTER( Product[ID],Sales[PID],Both ) ) : Override
cross-filter direction

VALUES(): VALUES( Orders[State] ) : Unique list of values in context

DISTINCT(): DISTINCT( Orders[Category] ) : Table of unique values

EARLIER(): VAR _t = EARLIER( Orders[Sales] ) : Reference row context from outer row

RELATED(): RELATED( Product[Category] ) : Fetch related value from 1-side table

RELATEDTABLE(): RELATEDTABLE( Sales ) : Return rows in related many-side table