Forum Discussion
Create new table by SELECTEDVALUE
I want to filter my table based on a slicer.
Below is my working:
Created a Slicer for 'TestData'[Date] and selected the date 2020-10-6.
Created the following 3 measures
SelectDate = SELECTEDVALUE(TestData[Date])
SpecifyDate = DATE(2020, 10, 6)
Checking = [SelectDate] = [SpecifyDate] 'Result is True
Created following 2 new tables
Table 1 = FILTER('TestData', 'TestData'[Date] = [SpecifyDate])
Table 2 = FILTER('TestData', 'TestData'[Date] = [SelectDate])
However, the content of Table 1 is not equal to the content of Table 2
I would like to know how to change the formula in Table 2 so that the Table 2 will equal to the Table 1.
Thanks so much!
Anonymous , You can not create a dynamic table based on the slicer filter.
You can create that as a var in a measure.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
1 Reply
- amitchandakSuper User
Anonymous , You can not create a dynamic table based on the slicer filter.
You can create that as a var in a measure.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.