Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Measure not working, when calculated column worked. Using Average.

I have a table with the columns "Value", "Analyte", "Color", "AnalyteType" and "DateEnter". I created a calculated column that averages by all those groups and takes only the last 12 months of data. ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Try like

     

    calculate(average(Main[Final]),filter(allselected(Main),Main[Analyte]=Max(Main[Analyte]) &&  Main[Color]=Max (Main[Color]) && Main[AnalyteType]="Lab"))

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Try like

 

calculate(average(Main[Final]),filter(allselected(Main),Main[Analyte]=Max(Main[Analyte]) &&  Main[Color]=Max (Main[Color]) && Main[AnalyteType]="Lab"))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

That worked great. Why use the "Max" instead of "Earlier"?