Forum Discussion

Ben1981's avatar
Ben1981
Icon for Helper III rankHelper III
2 years ago
Solved

Calculated table with measures included

Hi,

I have created a calculated table that is going to have some fields being existing sum and count measures. I added them in with no errors but the output hasn't worked. It looks like perhaps I need to group by but I'm not sure how to syntax that?

I tried two different methods...
Method 1

    SELECTCOLUMNS
        (
            'Table',"MONTH",[Month]
        ,   "Region",[region]
        ,   "Customers",[_COUNT_Customers]
        ,   "Debt",[_SUM_Debt]
        )
 
Method 2
    SELECTCOLUMNS
        (
            'Table',"MONTH",[Month]
        ,   "Region",[region]
        ,   "Customers",   
CALCULATE (
                SUM ( 'Table'[Balance] ),
                'Table'[Balance] > 0,
                'Table'[Status] = "OK"
            )
        )
Need Help
  • Anonymous's avatar
    Anonymous
    2 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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 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