Values in a measure in Power BI

[sophtee]

Hello Everyone,

I am new to using Power BI to create reports, I created a measure to do a calculation it works great however when I add other columns to the table it changes the values in the table. Is there a way to freeze the measured values?

[Anonymous · Accepted solution]

HI @sophtee,

Measure formulas are calculated based on current row context and filter context, they should dynamically changes when the current row/filter context changes.

If you want to fix the current result, you may need to add a variable with summarize function to keep specific calculation result instead of get dynamic result which interacted with current row and filter context.

Row Context and Filter Context in DAX - SQLBI

All the secrets of SUMMARIZE - SQLBI

Regards,

Xiaoxin Sheng