Forum Discussion
How to get the Overall Avg Daily Projects
Solution Supplier
Correct, the count is based on the project name as based on your explanation, you are trying to find how many unique (I assume) projects there are on a given day in the first instance, before finding the average.
If you want to factor in asset count, you just need to bring this into the "Count" expression: Calculate(distinctcount([Project Name]),[Asset Count] = 1)
Thank you, this does provide a numerical result but still unsure since the result value doesn't match the excel results using the same data. Just one last question, how would it look like if we don't consider the distinct count since I have an asset count already that gets the unique value? so just getting the average daily projects using the overall total asset count vs dates. thank you so much!