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:

abcde
sara1267
chiara5676
ambra8323

 

I have this measure: 

Measure = sum(Foglio1[b])+ sum(Foglio1[c])+ sum(Foglio1[d]) + sum(Foglio1[e])
 
I have a table and a gauge like this:  
I need to have the average of measure (18,6) instead of sum in both gauge and total in the table
How can I do?
Thanks
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]
    )
)

2 Replies

  • 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]
    )
)