Parameter in summarize

Hey Anonymous ,

The issue you're encountering is "Value which is in the Threshold variable is not getting passed". The value in the Threshold variable is not getting passed properly in your SUMMARIZE logic is often due to context transition or the way Threshold is referenced within the nested row context of FILTER and ADDCOLUMNS.

Root Cause

The variable Threshold is a scalar defined outside of the FILTER expression, but inside the ADDCOLUMNS, you're operating within a row context introduced by SUMMARIZE, which does not automatically convert into a filter context. As a result, DAX may not correctly evaluate Threshold for each row especially when used in CALCULATE inside ADDCOLUMNS.

Use VAR and restructure your code like this:

Filtered_Customs_Data_Input =
VAR Threshold = [Parameter Value] -- e.g., 500
VAR CustomsWithTotal =
    ADDCOLUMNS(
        SUMMARIZE('CBAM_Goods_InScope', [EntryIdentifier]),
        "TotalCustomsValue", CALCULATE(SUM('CBAM_Goods_InScope'[CustomsValue]))
    )
VAR FilteredIdentifiers =
    FILTER(
        CustomsWithTotal,
        [TotalCustomsValue] > Threshold
    )
RETURN
    FILTER(
        'CBAM_Goods_InScope',
        'CBAM_Goods_InScope'[EntryIdentifier] IN
            SELECTCOLUMNS(FilteredIdentifiers, "EntryIdentifier", [EntryIdentifier])
    )

Alternative: Use a Measure Instead of Variable

If [Parameter Value] is dynamic (like a disconnected slicer table), consider creating a measure and referencing it instead:

Threshold Measure = SELECTEDVALUE('Parameter Table'[Value])

And then:

VAR Threshold = [Threshold Measure]

Things to remember

• Always compute columns before filtering when dealing with nested contexts.

• Use SELECTCOLUMNS or VALUES to extract clean lists for use in IN clauses.

• Ensure Threshold is a scalar value — not a table or column.

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam