Calculate daily max result of minute level measure(s)

[kadapavel]

Hi

I have a measure which calculates a temperature delta between two sensors.

Measurement is taken once a minute, therefore I am interested in delta in the minute level.

My table has only 3 columns

PartitionKey     Value   TimeStamp

Currently measure is like that

Temperature differene B vs A = Max('RawDataCombine'[B_TEMP_NTC_C]) - Max('RawDataCombine[A_TEMP_NTC_C])

When I'm on minute level result is valid, but when I drill up, then it is agregated delta between some low and high points in hour, or day...  

It would be great to fix calculation of mesure to minute leven and then use another measure to look results on different level of Time hierarchy.

BR

Pavel

I would like to have another measure which would show max of minute level measure.

This way I would show what is the temperature delta in  day/week/month level and then drill through to the time when the minute measure had highest level.

[v-shex-msft · Accepted solution]

HI @kadapavel,

Nope, current measure formula will return different value based on hierarchy level, if you drill down or drill up, it will change the summary mode of records so formula cannot get previous result.

You need to add conditions to check row contents level and write specific calculation formula with filter to calculate on particular hierarchy level.

I'd like to suggest you refer to following link which told about handling hierarchy level calculation.

Clever Hierarchy Handling in DAX

Regards,

Xiaoxin Sheng