Forum Discussion
AVERAGE
HOW CAN I GET THE AVERAGE OF THE 3 HIGHLIGHTED ROWS.
Anonymous - because you have competing filters in [Active] and [LQ Active], you will likely have to redo the calculation part of [Active] (DISTINCTCOUNT) in [LQ Active] (rather than referring to the other measure).
Also, you may need to "clear" the filters from DATE when calculating the LQ measures (since you're showing the data in table, the measure will inherit the implicit filter from the table
...FILTER(ALL('Date'), 'Date[Year]'=2018...)
Time intelligence is always tricky in DAX/PowerBI - I have found that often you have to resort to building calculations for time comparisons twice.
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