DAX calculation from a table

@Greg_Deckler Hello Greg, sorry about that, does this help?

Business Unit File_date1 Count Count Type

jcastr02 , Try

Divide(sumx(filter(Table, Table[CountType]= "Headcount"),Table[Count]),AverageX(filter(Table, Table[CountType]= "Terms"),Table[Count]))

or

Divide(sumx(filter(Table, Table[CountType]= "Headcount"),Table[Count]),Divide(SumX(filter(Table, Table[CountType]= "Terms"),Table[Count]),Countx(filter(Table, Table[CountType]= "Terms"),Table[Count])))

if this does not work out. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

@amitchandak

In my visual, I'm showing it by month..... Query data provided below - + also screen shot of my visual table...

Attrition should be 12.55% (Sum of Terms / Average Headcount) and looking at this data by month

visual