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

[Diegoaraujo]

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

[tamerj1]

@Diegoaraujo 

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