Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

measure difference from filtered values

Hello Community,   I am trying to visualize an inclinometer chain composed of 20 sensors.  I receive the data every hour and I have to visualize a comparison (difference of values) of every measur...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    Maybe you can try to use the following calculate column format to replace your expression.

    Calculate column =
CALCULATE (
    AVERAGE ( 'Table'[value] )
        - CALCULATE ( AVERAGE ( 'Table'[value] ), 'Table'[reference_measurement] = 1 ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[last_measurement] = EARLIER ( 'Table'[last_measurement] )
            && 'Table'[sensor] = EARLIER ( 'Table'[sensor] )
    )
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Anonymous,

Maybe you can try to use the following calculate column format to replace your expression.

Calculate column =
CALCULATE (
    AVERAGE ( 'Table'[value] )
        - CALCULATE ( AVERAGE ( 'Table'[value] ), 'Table'[reference_measurement] = 1 ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[last_measurement] = EARLIER ( 'Table'[last_measurement] )
            && 'Table'[sensor] = EARLIER ( 'Table'[sensor] )
    )
)

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thnaks a lot for your help. 

I did not use exactly your solution. But it did inspire me to create my own. 

I used filters and eralier to do it.