Give constant values to a column or field

Question

How to give constant values to a column as any field value or any calculation? i want to provide the average for region to all the city belonging to that region as a cut off in a new column.

Answer 1

Hi Priyanka,

You can use a measure to fetch the average of the region as

avg reg = CALCULATE(AVERAGE(Orders[Sales]), Orders[Region]) and add the filter to region to select the region

Now use the measure and show the average wet to city average and regions average.