I need to gett category value next to all sub-category values

[irinabazghadze]

hiii,

my table is same:

CategoryName	SubcategoryName	averageprice	newcolumn
Accessories		52.3
	Bike Racks	120	52.3
	Bike Stands	159	52.3
	Bottles and Cages	8	52.3
	Cleaners	8	52.3
	Fenders	22	52.3
	Helmets	34	52.3
	Hydration Packs	55	52.3
	Lights	31	52.3
	Locks	25	52.3
	Panniers	125	52.3
	Pumps	22	52.3
	Tires and Tubes	19	52.3
Bikes		1530.6
	Mountain Bikes	1637	1530.6
	Road Bikes	1530	1530.6
	Touring Bikes	1425	1530.6

I need add new column same "newcolumn". so get category value next to all sub-category values.

[tamerj1]

Hi @irinabazghadze 

Please try

New Column =
CALCULATE ( [AveragePrice], ALL ( 'Table'[SubCategoryName] ) )

[irinabazghadze]

I get same value:

[tamerj1]

@irinabazghadze 

Do you have any column in the matrix other than category and subcategory?

[irinabazghadze]

NO,

this is my matrix visual:

[tamerj1]

@irinabazghadze 

Strange! What is the dax for averageprice measure?

[irinabazghadze]

@tamerj1 

averageprice = AVERAGE(Products[ProductPrice])

[tamerj1]

@irinabazghadze 

Oh! I think you're creating a calculated column. This is supposed to be a measure