Forum Discussion
Solved
Average
Hi All, hope you're well, Can you please help me with this? I'm trying to get the average site/visits per company, and I got the following measures. Site Visits = COUNTROWS(SUMMARIZE('3. Co...
Please try this one instead.
Avg Measure = AVERAGEX ( VALUES ( T4[CoWComp] ), [Site Visits/day] )Pat
Hi Pat ppm1, that's correct. Can you please elaborate a bit more? As you can see in my first post, these two DAX measures are coming from the data I got from previous years (massive table), so I dont have two custom columns. Hope this makes sense to you.
Site Visits = COUNTROWS(SUMMARIZE('3. CoW Productivity',DimProject[Project Number],'Calendar'[Date], DimCoWInsp[CoWInsp]))
Workdays = COUNTROWS(SUMMARIZE('3. CoW Productivity','Calendar'[Date]))
Thanks,
Please try this one instead.
Avg Measure =
AVERAGEX (
VALUES ( T4[CoWComp] ),
[Site Visits/day]
)
Pat