Passing result of calculatetable as a filter argument for another calculatetable

[blueFungi]

Hello everyone -

Long time lurker here... I am trying to use a table of values returned from a CALCULATETABLE to a list of values to filter on for another CALCULATETABLE, all within the same DAX measure... Is there a way to make this work? Every single example that I've encountered thus far requires a filter value to be pre-defined.

Any help/suggestions are greatly appreciated !!!!

 

[scottsen]

I typically use FILTER() rather than CALCULATETABLE() -- not sure if it for any particular reason... but you can certainly nest these. Maybe paste a sample expression that isn't working for you?