Forum Discussion
Tricky Month-Year Level Aggregated Total
Hi! I played around with one of your measures and got it to work. You should be able to apply similar logic to the rest. In the below sceenshot, your original measure of completetrans is showing and Measure2 is the one I adjusted and it returns the count at the row level, but the total is the sum of those counts.
Measure2 =
VAR _reportdate = MAX(ReportDateDimension[ReportDate])
VAR _filteredData =
FILTER(
Data,
Data[TransActualCompletionDate] <= _reportdate &&
Data[TransActualCompletionDate] > _reportdate - 7
)
RETURN
SUMX(
VALUES(ReportDateDimension[ReportDate]),
CALCULATE(
COUNTROWS(_filteredData),
ReportDateDimension[ReportDate] = EARLIER(ReportDateDimension[ReportDate])
)
)
Could you please share the revised .pbix file..
- audreygerred1 year agoSuper User
Actually my measure is wrong - it's closer, but wrong. 38 plus 71 = 109, but the measure is showing 142.