Forum Discussion
AverageX not affecting calculation in Matrix
Hi all - Attempting to find an average of CountDistinct values over a period of time (including 0 where no record was recorded). Here is my calculation for Distinct activity by employee, by week:...
amitchandak
Super User
Super Useraplask105 , Try like
Averagex(summarycolumn, calculate([@cntD])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.