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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

oftentimes Power BI can provide a graphical answer - measures are only required when that is not possible.  In your case you can make a small change to the data model to allow filtering of the dimension table from the fact table

and then you can use a table or matrix visual to show the result.