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...
AntrikshSharma
Community Champion
Community ChampionIf 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?