Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago
If you want to remove filters then use REMOVEFILTERS, can you show what your data looks like?
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi thanks for the answer...

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

    tab 1

    Id CodeCluster Value
    1A4
    2B20
    3D10
    4C8
    5A9
    6A15
    7C7
    8B2

    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 CodeCluster valueAverageNorm
    1A490,4
    2B20211,0
    3D10101,0
    4C881,1
    5A991,0
    6A1591,6
    7C780,9
    8B22211,0

     

    How I can implement in DAX?