Store Calculated Values into table

Hi CYParker ,

I feel like you need a summary table based on your description?

You can use the New Table function provide by Power BI via SUMMARIZE( ).

For example, the data looks like this:

Table expression:

Table =
SUMMARIZE (
    'Fact Table',
    [Date].[Year],
    [Date].[Month],
    "Total Expense", SUM ( 'Fact Table'[Expense] ),
    "Total Debit", SUM ( 'Fact Table'[Debit] )
)

Result:

This expression also works in measure. What's difference between measure and calculate column, please refer this:

Calculated Columns and Measures in DAX - SQLBI

When you refresh your data, the new calculation table is recalculated, however, it does not change when you do some interaction with any of the visuals in the report. report can only fetch data from the model(table), it cannot return data. So, you cannot transcribe some values into the model(table) for any interaction you do.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.