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?
1 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
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
