Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating an Average across two tables

Hi, I'm struggling to calculate an average from data held in two tables and would really appreciate some help as I'm quite new to measures / DAX etc.   I have a table that holds records of meeting...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

    Try to create a measure:

    Measure = 
DIVIDE(
DISTINCTCOUNT(Activity[Meeting]),SELECTEDVALUE(Headcount[Headcount]))

    Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

Try to create a measure:

Measure = 
DIVIDE(
DISTINCTCOUNT(Activity[Meeting]),SELECTEDVALUE(Headcount[Headcount]))

Result:

Please refer to the attachment below for details.

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.