Set modifier operators: =, +=, -=, *= in Power BI

What it does in Qlik

Inside a modifier, the assignment operator decides how the listed values combine with the current selection in that field:

• Region={'North'}: replace the selection with North.
• Region+={'North'}: current selection plus North.
• Region-={'North'}: current selection minus North.
• Region*={'North'}: only North, and only if it is in the current selection.

Qlik example

Sum({<Region-={'North'}>} Sales)   // everything selected except North
Sum({<Region*={'North'}>} Sales)   // North only if North is selected/possible
Sum({<Region+={'North'}>} Sales)   // the selection plus North

Power BI equivalent

*= (intersect): KEEPFILTERS

KEEPFILTERS intersects the new filter with the existing one instead of replacing it.

Sales North if selected =
CALCULATE ( [Sales], KEEPFILTERS ( Customer[Region] = "North" ) )

-= (exclude)

Sales excl North =
CALCULATE (
    [Sales],
    KEEPFILTERS ( Customer[Region] <> "North" && NOT ISBLANK ( Customer[Region] ) )
)

The NOT ISBLANK part copies Qlik's behaviour: a selection in Region can never include records where Region is null. Remove it if you want blank regions included.

+= (union with the selection)

DAX has no += shortcut. Build the set of values explicitly. TREATAS is needed because a UNION with a table constructor loses the column lineage.

Sales selection plus North =
CALCULATE (
    [Sales],
    TREATAS ( UNION ( VALUES ( Customer[Region] ), { "North" } ), Customer[Region] )
)

Related pages