DAX - Divide Value in Column by the Count of another Column in a separate table

[Anonymous]

Hi there, 

I am attempting to do a simple calculation to understand the number of Keys created per headcount. Headcount values are in a column as below, and the table below shows the Count of these Keys. Therefore I would like to Divide "Count of Key" by Headcount. These columns are in separate tables and the relationship is Many:Many (default) with a Single direction (Headcount table filters Key Table) - which was done by default.

 So far all of my attempts have caused the visualisation to fail. Any help is very much appreciated. Thanks

[PhilipTreacy · Accepted solution]

@Anonymous 

Your Headcount column is Text.  Change it to Whole Number.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Thanks - unfortunately i am still struggling. I have merged the query into the same table so its now a single table.

DAX is = DIVIDE(COUNT(Table1[Key]),SUM(Table1[Headcount]) 

I get the below error:

[amitchandak]

@Anonymous , difficult to tell, but better to create one or more bridge table and anayze on that.

Across common param

new measures = divide([Count of Key],[Headcount]) // Both are measures

https://www.seerinteractive.com/blog/join-many-many-power-bi/