Get the Average from a column without filters

[RevD]

Need help on the below data. i want the ClothsWeight and HomeWeight to be appearing for all the rows. Without having any filters on it. I tried allexcept , All But it is not working. Below is the code i have now 

HomeWeight = CALCULATE(

    AVERAGE(Sheet3[WeightedValue]),

    Sheet3[Type] IN { "home" }

)

Quarter	Type	WeightedValue	index	filter	Groups
Q2 2019	Cloths	0.41	1	Person	T2T
Q2 2019	cloths	0.41	2	Person	T2T
Q2 2019	cloths	0.41	3	Person	T2T
Q2 2019	Home	0.05	4	Person	B2B
Q2 2019	Home	0.05	5	Owner	B2B
Q2 2019	Home	0.05	6	owner	B2B
Q2 2019	Home	0.05	7	Person	B2B
Q2 2019	Vehicle	0.54	8	Person	B2B
Q2 2019	Vehicle	0.54	9	owner	T2T
Q3 2020	cloths	0.45	10	owner	T2T
Q3 2020	cloths	0.45	11	owner	B2B
Q3 2020	Home	0.05	12	Person	B2B
Q3 2020	Home	0.05	13	Person	B2B
Q3 2020	Home	0.05	14	owner	B2B
Q3 2020	Home	0.05	15	owner	B2B
Q3 2020	Vehicle	0.5	16	Person	T2T

[ryan_mayu]

@RevD 

please try this

Measure = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALL('table'),'table'[Type]="Home"))

Measure2 = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALL('table'),'table'[Type]="cloths"))

[RevD]

With that measure i am getting the overall Average value. But i want the below output

For Q2 2019 Cloths i want .41 in all rows for clothsWeight

For Q2 2019 Home i want .05 in all rows  for HomeWeight

For Q3 2020 Cloths i want .45 in all rows for clothsWeight

For Q3 2020 Home i want .05 in all rows  for HomeWeight

[ryan_mayu]

@RevD 

pls try this

Measure2 = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALLEXCEPT('table','table'[Quarter]),'table'[Type]="cloths"))

[RevD]

The Solution is working for measures for same table. I have an additional measures for which i use date table and get Quarter from it for previous Quarter calculation. In the Relationship i join on the Column DateCustom with Values 4/1/2019 and 7/1/2019. for Q2 2019 AND Q3 2019. 

In the Visual i use YearQuarter from Dim Date 

Dim Date = CALENDAR(date(2019,1,1),date(2021,12,31))

CLOTHSWeight = CALCULATE(AVERAGE(Sheet3[WeightedValue]),FILTER(ALLEXCEPT('Sheet3',Sheet3[Quarter]),Sheet3[Type]="cloths")). I t gives me overall total again 

Thanks for the help

[ryan_mayu]

@RevD 

I didn't create full calendar just quarter

Measure = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALLEXCEPT('table','table'[Quarter],DIMTIME[Quarter]),'table'[Type]="cloths"))

please try if this works for u.