Forum Discussion

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
10 months ago
Solved

Dynamic Table Creation???

I've created some very simplfied mock data that hopefully explains what I'm trying to achieve for a user.  Tables A & B are imported.  Table C is a summarised from Table A, with columns added from Ta...
Need Help
Tips and Tricks
danextian's avatar
danextian
Icon for Super User rankSuper User
10 months ago
  I tried using a measure in the SUMMARIZE(FILTER...) that was based on button slicer but it resulted in an empty Table C.

You probably used SELECTEDVALUE ('table'[filter column]). In the context of a calculated table, there isn't a single value selected as calc tables are not aware of any slicer selection thus the filter value is blank resulting to a blank table.