Forum Discussion

SantiagoTorres's avatar
SantiagoTorres
Helper I
3 years ago
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...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Please try this one instead.

     

    Avg Measure =
AVERAGEX (
    VALUES ( T4[CoWComp] ),
    [Site Visits/day]
)

     

    Pat

SantiagoTorres's avatar
SantiagoTorres
Helper I
3 years ago

Hi Ashish Ashish_Mathur , hope you're well. Sorry for the late reply,

 

I'm kind of new to interacting here, and I dont know how to provide the information you're requesting. I couldn't find a way to load a file. Regarding the expected results, please refer to my first post; I believe I provided all the information there.

 

Thanks for your help,

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Upload the file to Google Drive and share the download link here.  Show the expected result clearly.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      Share the download link of the PBI with the measures already there.  Clearly show the problem there and the expected result.