Hi @PowerVisualBI ,
There is a difference between measure and calculated column, and it is not possible to convert the formula directly between the two.
For measure:
- Calculated using all of the filters: Contextual Filtering.
- Isn’t saved and isn’t calculated ahead of time.
- When you put it on a report page and alter a slicer, filter, or tap on a column chart or any other visual to highlight and it affects this measure’s value, it’s computed on the go.
- Calculation uses the CPU.
For calculated column:
- Calculation by row: Row Context
- Retained in memory (consumes RAM)
- Computed at the time the report is refreshed (either scheduled basis or manual)
-
Common conversion steps are referenced below:(convert a measure to a calculated column in Power BI)
- Step 1: Pick the measure column that you want to convert into a calculated column (do not tick the checkbox to include the column in the sheet; only select the column).
- Step 2: In the “Default Summarization” selection, any aggregation will be applied by default.
- Step 3: From the drop-down menu, choose “Do Not Summarize.”
For more details, you can read related blog:
Calculated Column and Measure in Power BI (powerbiconsulting.com)
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
