Forum Discussion
Running Total for Count Distinct Measure
I am trying to count distinct values in a by date and create a new measure that calculates the cumulative sum of the distinct counts as the time period progresses: The table on the left is representa...
Assuming you have a calendar table
https://exceleratorbi.com.au/power-pivot-calendar-tables/
something like this
Distinct products =DISTINCTCOUNT(data[product])
Running total =CALCULATE(sumx(values(calendar[date]),[Distinct Products]),Filter(All(calendar),calendar[date] <= max(calendar[date])))
use the calendar date column in your visual.
Hi Anonymous ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards,
Icey