Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Creating a table through DAX

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
  • 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.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous 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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Greg_Deckler
      Community Champion

      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.