Creating a table through DAX

[anonymous15]

Hi guys, I  have recently started working with Power BI and I need some help with a problem that I'm facing.

I am trying to create a table which is going to select some values. Below is the expression for that

TemporaryTable =

VAR SelectedLeafMatch = [MatchedLeaf] // this is another dax measure that I have created

RETURN

        CALCULATETABLE( SUMMARIZE (

        'CALCULATIONS',

        'CALCULATIONS'[PROJECT_NAME],'CALCULATIONS'[PROJECT_NUMBER]),'CALCULATIONS'[LEAF_ID]= SelectedLeafMatch)

This expression is working well when I'm hardcoding the SelectedLeafMatch but when I'm passing the MatchedLeaf then it is not working

[anonymous15]

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.

[Greg_Deckler · Accepted solution]

@anonymous15 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.

[Greg_Deckler]

@anonymous15 Mixing measures with calculated columns and tables almost never works. This is because measures are dynamic while calculated tables and columns are only calculated when refreshing data (generally). If you need a dynamic table, you can calculate the table and assign it to a VAR within a measure.