Forum Discussion
AVERAGE
HOW CAN I GET THE AVERAGE OF THE 3 HIGHLIGHTED ROWS.
dedelman_clng I think I see. So my LQ Active would look something like:
LQ Active = CALCULATE(DISTINCTCOUNT(M3[co]),FILTER(M3,M3[startDate]<=MAX('Date'[Date])&&M3[enddate]>=MAX('Date'[Date])),FILTER(ALL('Date'),'Date'[Year]=2018&&'Date'[Quarter]="Qtr 1")))
Yes - looks like you're on the right track