Forum Discussion
Solved
Cumulative Total
I have a fact table and a dimension table, in my fact table there is column "ID" I want to the cumulative sum of the unique Id, please see the attached picture.
arifulice09 , Try a measure like
calculate(sumx(values(Table[Date]), calculate(distinctCOUNT(Table[ID]))), filter(allselected(Table), Table[Date] <= Max(Table[Date])))
amitchandak Yes, it is giving the correct answer, thank you:)
3 Replies
arifulice09 , Try a measure like
calculate(sumx(values(Table[Date]), calculate(distinctCOUNT(Table[ID]))), filter(allselected(Table), Table[Date] <= Max(Table[Date])))
amitchandak it is good for daily data, but I am facing a problem with weekly data, please see the attached below.
amitchandak Yes, it is giving the correct answer, thank you:)