Forum Discussion
DAX - Filter All Columns from a Table Based on What-If Parameter
Hi ElioXh ,
According to your description, I understand that you want to filter the table by measure with parameter. Unfortunately, New table Functions does not dynamically change as the measure changes. However, you can create a new table and use What-If Parameter to filter the data in the table.
You can follow these steps:
1.Add a parameter
2.Add a measure
Measure =
IF (
SELECTEDVALUE ( RunData[RunNum] ) = [Parameter Value],
'Parameter'[Parameter Value],
BLANK ()
)
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Yifan Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yifan,
Thanks for your help, a sample pbix showcasing the issue can be dowloaded at the following link.
Applying the parameter to a single column works exactly as intended, and can be driven by the parameter slider, but the issue for my end use-case is I have over 300 columns in my table, and defining measures for each column is not viable. Which is why I want to create a subset table of my original table, containing only the filtered rows of interest.
If I define a filtered table as below, this works exactly as desired:
FilteredTable = FILTER(RunData,RunData[RunNum]=4)
But if I try and link the filter to use the parameter, that yields a blank table.
FilteredTable = FILTER(RunData,RunData[RunNum]=SELECTEDVALUE(Parameter[Parameter]))
Is there a way to create the subset table in a way that can be updated based on a parameter?