Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    You can create a Measure:

     

    Attrition = Sum(Separations[Separations])/SUM(HeadCount[HeadCount])

    And use it in a table visual 

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

You can create a Measure:

 

Attrition = Sum(Separations[Separations])/SUM(HeadCount[HeadCount])

And use it in a table visual 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thank you Vvelarde it worked for me... :-) i was just missing a single bracket to close the first argument....