Forum Discussion
Ratio between two tables
Hi This is my first post and question, hope someone helps me to resolve my query. I have two different tables, Table1 (Employee Separations) and Table2 (Headcount). I have imported both table...
Anonymous
You can create a Measure:
Attrition = Sum(Separations[Separations])/SUM(HeadCount[HeadCount])
And use it in a table visual
Anonymous
You can create a Measure:
Attrition = Sum(Separations[Separations])/SUM(HeadCount[HeadCount])
And use it in a table visual
This is the simple example what i want to do... first i want to calculate the table 1(Separations) Names, then table2(headcount) Names. once i get the result like 5 separations and 5 headcounts. then i would like to make a ratio of 5 / 5 = 1.