Forum Discussion
Creating a table through DAX
Anonymous You can use a VAR to store a dynamic, calculated table within a measure. Unfortunately you have to do that in every measure where you want the table because measures can't return tables.
thanks for you reply Greg_Deckler ..I do need to calculate a dynamic table. To provide further context, I'm using two filters and as users select values from the filter, [MatchedLeaf] calculates a value based on these filters and returns a value. I need to pass this value to 'CALCULATIONS'[LEAF_ID] to return selected values from the table. The idea is to use this table to perform further calculatons. In simple terms, I want the table to return values evrytime user makes a selection. Is there a way I can achieve this? Dynamic table is the only solution that I can see but is there anything else that can be done? Even for dynamic I'm not able to figure out a way as it's not working with varible, though it works when I hardcode the value.
Anonymous You can use a VAR to store a dynamic, calculated table within a measure. Unfortunately you have to do that in every measure where you want the table because measures can't return tables.