Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX

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 1...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

    calculate(averagex(filter(table,table[flag]=1),value/12))
amitchandak's avatar
amitchandak
Super User
6 years ago

Try

calculate(averagex(filter(table,table[flag]=1),value/12))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.