Divide rows for the corresponding aggregate

[Anonymous]

Hi, I'm a newbie at DAX...
So far I've managed my reports in Power BI with exel and vlookup calculations only... but they're exonerating!!
I would like to go one step beyond writing my formulas not in excel but directly in BI.

I have a series of stores with their own reference clusters and I calculate sales average per Cluster (I managed it with a quick measure) Now I should divide the sales of the room by its average...
I tried Calculate but I don't have to apply a single filter I need all the clusters.

Thanks !!

[AntrikshSharma]

If you want to remove filters then use REMOVEFILTERS, can you show what your data looks like?

[Anonymous]

Hi thanks for the answer...

I will try to explain better. I ha ve two tabs

tab 1

Id Code	Cluster	Value
1	A	4
2	B	20
3	D	10
4	C	8
5	A	9
6	A	15
7	C	7
8	B	2

and I computed in tab 2  the aggragate average for custer ( as pivot excel with field average).

Now I would obtaina  in tab 2 le value ove cluster and than divide the value for its average, in this way

Id Code	Cluster	value	Average	Norm
1	A	4	9	0,4
2	B	20	21	1,0
3	D	10	10	1,0
4	C	8	8	1,1
5	A	9	9	1,0
6	A	15	9	1,6
7	C	7	8	0,9
8	B	22	21	1,0

How I can implement in DAX?