Forum Discussion
Creating a new table from a current table
Hi, I'm wondering if anyone can help. I have a table in my BI desktop called Trip Detail. I'm trying to create a measure that calulates the average number of trucks used each week in 2021. Th...
Hi parry2k
I don't think it's as simple as that. Each truck has a unique truck number.
Currently I'm calculating the distinct count of trucks we've used in 2021 at one point. I need to calculate the average distinct count of trucks for each week in 2021.
Week 2 we used 617
Week 4 we used 637
Week 5 we used 642
Week 6 we used 641
For an average of 634 trucks/week in 2021
Distinct Count of Trucks/Week = (CALCULATE(COUNT(DimTractor[TractorAK]),FILTER('Trip Detail','Trip Detail'[Year]=2021)))
Forgot to add my current measure