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
