Filter Table

[Pep69saravia]

Good morning, my problem is the following, I have a selector by week, which correctly returns the value of the week number in a card, "Filter = SELECTEDVALUE(Calendar[Week])", I also get the value of the first day of that week, Monday = FIRSTDATE('Hours Worked'[Date])
Up to here okay.
Now I want to represent the data of that week or that day, creating a table with the FILTER function
HoursSelect = Var WeekSel = SELECTEDVALUE(Calendar[Week])
return
FILTER('Hours Worked','Hours Worked'[Week] = WeekSel)
If instead of a variable, I assign the value of the week, if that works for me,
Thanks

[KNP]

I'm confused as to why you need to go about it this way. Maybe some more detail would help.

Can you include a screenshot of your data model showing the relationships?

Some dummy data, pasted as data would be helpful.

Also, what is your desired outcome, what is not working currently? 

[v-xiaotang]

Hi @Pep69saravia 

>>  creating a table with the FILTER function

that is not possible to create a table with the value selected in slicer dynamically. But if you want to dynamically create a virtual table, it is feasible, but you still need to perform some aggregation operations on it to display the value in visual.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Pep69saravia]

How should I do it? What do you advise me, because i'm lost, Thanks