Forum Discussion
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
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_DecklerCommunity 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.
- AnonymousNot 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_DecklerCommunity 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.