Forum Discussion
Cumulative progress calculation using discrete updates to progress
For anyone out there interested, I ended up getting the result I was looking for using the following:
measure = calculate(sumx(DISTINCT(table[document_number])),filter(allselected(table[document_received_date]),sheet[document_received_date]<=max(sheet[document_received_date])))
Where document number is constructed such that future revisions have the same numbering and thus are not distinct.
Note that for a given day the total will be shown but the cummulative sum avoids including the previous versions in the count.
Ammii11 , You have try meausre like
Sumx(SUMMARIZE(Table, Table[Document Name], Table[Issue Purpose], Table[document (hrs)]), Table[document (hrs)])
Or create a column
UniqueDocument = CONCATENATE([Document Name], [Issue Purpose])
and a measure like
Cumm =
CALCULATE(
SUM('Table'[Progress Earnt (%)]);
FILTER(
ALL('Table');
'Table'[UniqueDocument] IN VALUES('Table'[UniqueDocument]) &&
'Table'[Date] <= MAX('Table'[Date])
)
)
For anyone out there interested, I ended up getting the result I was looking for using the following:
measure = calculate(sumx(DISTINCT(table[document_number])),filter(allselected(table[document_received_date]),sheet[document_received_date]<=max(sheet[document_received_date])))
Where document number is constructed such that future revisions have the same numbering and thus are not distinct.
Note that for a given day the total will be shown but the cummulative sum avoids including the previous versions in the count.