Parameter in summarize

Thanks for the update. If the revised approach didn’t solve the issue, let’s take a deeper look at possible reasons and other workarounds:

Potential Issues

1. [Parameter Value] might not be evaluated as expected

   • If [Parameter Value] is coming from a slicer or a disconnected table, it must be a scalar. Use SELECTEDVALUE() to ensure it returns a single value:

     VAR Threshold = SELECTEDVALUE('Parameter Table'[Value], 500)  // fallback to 500

2. Threshold might be blank

   • If no value is selected in the parameter slicer, [Parameter Value] may return blank, causing all rows to be filtered out. You can guard against this with:

     VAR Threshold = IF(ISBLANK(SELECTEDVALUE('Parameter Table'[Value])), 0, SELECTEDVALUE('Parameter Table'[Value]))

3. Data Type Mismatch

   • Double-check if CustomsValue and the parameter are both numeric. If one is text and the other is numeric, the comparison may silently fail.

Try this full version with explicit fallback and clean context flow:

Filtered_Customs_Data_Input =
VAR Threshold = SELECTEDVALUE('Parameter Table'[Value], 0)  // default to 0 if nothing selected

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])
    )

Debug Tip

Temporarily add a measure like this to check what your parameter is returning:

Measure_CheckThreshold = SELECTEDVALUE('Parameter Table'[Value])

Add it to a card visual to verify it’s not blank or unexpected.

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