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

Question

Hi Guys,I've created a new table based on an existing one using the following DAX:&nbsp;New&nbsp;Table&nbsp;=SUMMARIZECOLUMNS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor'[Hourly&nbsp;Wind&nbsp;Max&nbsp;Gust&nbsp;10m&nbsp;(km/h)],&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor'[Year],&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor'[Hourly&nbsp;Wind&nbsp;Max&nbsp;Gust&nbsp;10m&nbsp;(km/h)]&nbsp;&gt;&nbsp;80))&nbsp;This new table has 7 rows only -&nbsp; which is correct for what I need.&nbsp;However, instead of having the fixed value in blue&nbsp;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.&nbsp;The problem is that when I have it as fixed value&nbsp;80&nbsp;it works, but when I use the parameter, it does not work.&nbsp;Below is the DAX I tried to use linking to the parameter:New&nbsp;Table&nbsp;=SUMMARIZECOLUMNS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor'[Hourly&nbsp;Wind&nbsp;Max&nbsp;Gust&nbsp;10m&nbsp;(km/h)],&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor'[Year],&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Original&nbsp;-&nbsp;wind&nbsp;cap&nbsp;factor'[Hourly&nbsp;Wind&nbsp;Max&nbsp;Gust&nbsp;10m&nbsp;(km/h)]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&gt;&nbsp;SELECTEDVALUE&nbsp;(&nbsp;'.Wind&nbsp;speed'[Wind&nbsp;speed]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;))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.&nbsp;Would you guys be able to help me make it work?&nbsp;Below is a photo of how this parameter is shown for the users:Thanks,Diego&nbsp;&nbsp;

tamerj1 · Answer

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

Forum Discussion

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

1 Reply

Related content

Alias on SummarizeColumns

DAX query with SUMMARIZECOLUMNS - Optimization

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

SummarizeColumns() and AddMissingItems()

Parameter in summarize