DAX

[Anonymous]

Hi,

I have a dataset of production values with dates and a flag column indicating the first production value in the series.

Is it possible to force a measure to divide the flagged values by 12 and take an average of the remaining values?

Thanks

[amitchandak · Accepted solution]

Try

calculate(averagex(filter(table,table[flag]=1),value/12))

[Anonymous]

@amitchandak Thanks you for your response.

This works to give me the correct single value for flagged data point but does not produce an average for the remaining months i.e. all remaining months are null.