When creating a new table using Summarizecolumns, can I use a parameter?

Diegoaraujo — Wed, 27 Sep 2023 07:51:15 GMT

Hi Guys,

I've created a new table based on an existing one using the following DAX:

New Table =
SUMMARIZECOLUMNS (
    'Original - wind cap factor'[Hourly Wind Max Gust 10m (km/h)],
    'Original - wind cap factor'[Year],
    FILTER (
        'Original - wind cap factor',
        'Original - wind cap factor'[Hourly Wind Max Gust 10m (km/h)] > 80))

This new table has 7 rows only - which is correct for what I need.

However, instead of having the fixed value in blue 80, I would like to use a parameter (numeric field) I've created in the visuals - so that the user could change the parameter as he needs and the numbers get recalculated based on that.

This parameter is created under the Modelling tab - New pArameter - Numeric Field.

The problem is that when I have it as fixed value 80 it works, but when I use the parameter, it does not work.

Below is the DAX I tried to use linking to the parameter:

New Table =
SUMMARIZECOLUMNS (
    'Original - wind cap factor'[Hourly Wind Max Gust 10m (km/h)],
    'Original - wind cap factor'[Year],
    FILTER (
        'Original - wind cap factor',
        'Original - wind cap factor'[Hourly Wind Max Gust 10m (km/h)]
            > SELECTEDVALUE ( '.Wind speed'[Wind speed] )
    )
)

When I use the above DAX linking to the parameter, the amount row of grows as it does not summarize the columns as I wanted.

Would you guys be able to help me make it work?

Below is a photo of how this parameter is shown for the users:

Thanks,

Diego

Re: When creating a new table using Summarizecolumns, can I use a parameter?

tamerj1 — Wed, 27 Sep 2023 08:43:33 GMT

Diegoaraujo

Calculated tables do not interact with the filter context. You have to rely completely on measures.

topic When creating a new table using Summarizecolumns, can I use a parameter? in DAX Commands and Tips

When creating a new table using Summarizecolumns, can I use a parameter?

Re: When creating a new table using Summarizecolumns, can I use a parameter?