Forum Discussion
Divide rows for the corresponding aggregate
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 !!
2 Replies
- AntrikshSharma
Community Champion
If you want to remove filters then use REMOVEFILTERS, can you show what your data looks like?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?
