Forum Discussion
Calculated table with measures included
- Anonymous2 years ago
HotChilli Thanks for your contribution on this thread.
Hi Ben1981 ,
Base on your description, it seems like you’re trying to create a calculated table using measures in Power BI. The measures are dynamic and context-dependent, meaning their values can change based on the filters applied to the report or visual. However, the calculated tables are computed during the loading of the data model and are static, they do not change unless the data is refreshed. Therefore, you cannot use measures which are dynamic inside calculated tables which are static.
You can update the formula of calculated table as below to get the similar requirement, please check if that is what you want.
SUMMARIZE ( 'Table', 'Table'[Month], 'Table'[region], "Customers", COUNT ( 'Table'[CustomerColumn] ), "Debt", SUM ( 'Table'[DebtColumn] ) )Best Regards
HotChilli Thanks for your contribution on this thread.
Hi Ben1981 ,
Base on your description, it seems like you’re trying to create a calculated table using measures in Power BI. The measures are dynamic and context-dependent, meaning their values can change based on the filters applied to the report or visual. However, the calculated tables are computed during the loading of the data model and are static, they do not change unless the data is refreshed. Therefore, you cannot use measures which are dynamic inside calculated tables which are static.
You can update the formula of calculated table as below to get the similar requirement, please check if that is what you want.
SUMMARIZE (
'Table',
'Table'[Month],
'Table'[region],
"Customers", COUNT ( 'Table'[CustomerColumn] ),
"Debt", SUM ( 'Table'[DebtColumn] )
)
Best Regards
- Ben19812 years ago
Helper III
Yeah that did the trick, thanks 🙂