Parameter in summarize

Hi Anonymous ,
Thank you again for the follow-up. I would be happy to assist you!

Hardcoding a value like > 150 works because calculated tables are created at model load. But when using a dynamic value from a slicer (like Threshold), the table does not update. That is expected because calculated tables are not dynamic in the same way visuals or measures are, since calculated tables do not respond to slicers , only DAX measures do. For dynamic behavior, measures with visual-level filters are the way to go.

To get dynamic filtering based on a slicer, the best approach is to use the original CBAM_Goods_InScope table in your visuals. Then, create a measure like ShowRow that checks if each entry meets the selected threshold. Finally, apply a visual-level filter where ShowRow = 1, this gives you the same result you wanted from the calculated table, but in a way that responds to slicer changes.

I hope this helps.

Thank you.

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