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
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.
Ashish_Mathur
3 years agoSuper User
Hi,
Share the download link of the PBI with the measures already there. Clearly show the problem there and the expected result.