Forum Discussion

ThomasRichard's avatar
ThomasRichard
Helper I
2 years ago

Reference a Text Cell as a filter for Summarized Table

Hi all,   I am working with football GPS data. Each row of my data base is a Player Name, a Date, and hundreds of different metrics.   I would like to create a summarized table for total values o...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

ThomasRichard , Tables can not be dynamic. This means you can NOT use a filter and slicer.

 

So better to create a measure and use that with Name in the table visual. You can use a slicer for Weekly Motorcycles, no need to add that to measure

 

calculate(Sum(Table[Total Distance]) , filter(Table, Table[Period Session]= "Team Session") )  

 

//Use the correct table and columns