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
Please try this measure expression. Replace T4 with your actual table name.
Avg Measure =
AVERAGEX (
VALUES ( T4[CoWComp] ),
CALCULATE ( AVERAGEX ( t4, T4[Site Visits] / T4[Workdays] ) )
)Pat
Hi Pat, thanks for your response,
When you get a gap, can you please tell me if Im doing something wrong here,
Avg Site Visits/Day = AVERAGEX( VALUES( DimCoWCom[CoWComp] ),CALCULATE( AVERAGEX('2. Observations', [Site Visits] / [Workdays] ) ) )These are the results I'm getting, which are not correct.
CoWComp Avg Site Visits/Day Company 1 1 Company 2 1 Company 3 1 Thanks for your time,
Santiago Torres
Hi Pat ppm1 , thanks for your response,
When you get a gap, can you please tell me if Im doing something wrong here,
Avg Site Visits/Day = AVERAGEX( VALUES( DimCoWCom[CoWComp] ),CALCULATE( AVERAGEX('2. Observations', [Site Visits] / [Workdays] ) ) )These are the results I'm getting, which are not correct.
CoWComp Avg Site Visits/Day Company 1 1 Company 2 1 Company 3 1 Thanks for your time,
Santiago Torres
Looks like you are referencing measures in your inner AVERAGEX, while I used columns. Please switch to column references and it should work.
Pat
