Forum Discussion

Giada90's avatar
Giada90
Icon for Helper IV rankHelper IV
3 years ago
Solved

average instead of sum

Hi, I have a database like this: a b c d e sara 1 2 6 7 chiara 5 6 7 6 ambra 8 3 2 3   I have this measure:  Measure = sum(Foglio1[b])+ sum(Foglio1[c])+ sum(Fogli...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    My measure =
IF (
    ISINSCOPE ( 'Foglio1'[a] ),
    SUMX ( 'Foglio1', 'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e] ),
    AVERAGEX (
        'Foglio1',
        'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e]
    )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

My measure =
IF (
    ISINSCOPE ( 'Foglio1'[a] ),
    SUMX ( 'Foglio1', 'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e] ),
    AVERAGEX (
        'Foglio1',
        'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e]
    )
)
  • Giada90's avatar
    Giada90
    Icon for Helper IV rankHelper IV
    3 years ago

    thanks!