Forum Discussion
SantiagoTorres
3 years agoHelper I
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...
- 3 years ago
Please try this one instead.
Avg Measure = AVERAGEX ( VALUES ( T4[CoWComp] ), [Site Visits/day] )Pat
Ashish_Mathur
3 years agoSuper User
Hi,
Upload the file to Google Drive and share the download link here. Show the expected result clearly.
SantiagoTorres
3 years agoHelper I
Hi Ashish_Mathur, thanks for your patience. Please see below the data with formulas in Excel with the results expected to get in PBI.