Forum Discussion
measure difference from filtered values
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
Thanks a lot for your reply.
It is the exact same Measure that I sued to calculate the displacement as mentioned in my post above. But it is not working for all the values but only for the rows where column reference_measurement = 1.
I even created a calculated column to be able to control the resulted values of my measure as follows:
We can see in the picture, that column Verschiebung is equal to 0 in the rows where reference_measurement = 1 which means the substraction of the DAX formula is actually working for these rows. But looking at the rows where reference_measurement = 0, I get in column Verschiebung the exact same values that I have in column Value which means that the subtraction that I am trying to execute is not effective for the rows where reference_measurement = 0 and this is my challenge. I want this Dax Formula to be effected for all the rows of the table.
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
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.