Filtering Wide Aggregation Table - How to ?

Hello SergioTorrinha,

Here's a conceptual example to apply dynamic filtering that responds to the selection.

Dynamic Filter Measure = 
VAR SelectedField = SELECTEDVALUE(FieldSelectionTable[FieldName], "decimal_field_1")
VAR FilterValue = 100 // This could be dynamically set through another mechanism, like a parameter
RETURN
    SWITCH(
        SelectedField,
        "decimal_field_1", CALCULATE(SUM(Table[decimal_field_1]), Table[decimal_field_1] > FilterValue),
        "decimal_field_2", CALCULATE(SUM(Table[decimal_field_2]), Table[decimal_field_2] > FilterValue),
        ...
        "decimal_field_50", CALCULATE(SUM(Table[decimal_field_50]), Table[decimal_field_50] > FilterValue),
        BLANK()
    )

 Just a note - Performance might be impacted with very wide tables and complex dynamic measures, especially on large datasets.