Calculated table with measures included

[Ben1981]

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"

            )

        )

[Anonymous · Accepted solution]

@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

[Ben1981]

Yeah that did the trick, thanks 🙂

[HotChilli]

Not enough information to help you.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...