adding row values only

[Easley06]

Hi, 

how can i add only the row values per month because of the total.

i have filter for month and year and im using card visual 

expected output should be 4.91 

Thankyou.

[BrianConnelly]

You can tackle it by summarizing, Ill break it down into very seperate steps....

result =

VAR summaryTable = SUMMARIZECOLUMNS( MonthYear, "Attrition",DIVIDE([Count Seperated],[Ending Employ],0))

VAR attritionResult = SUMX(summaryTable,[Attrition])

RETURN attritionResult

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Easley06]

hi sir got an error 

[BrianConnelly]

THe error message tells you that its on line 3.  Not sure yet as I am not testing, by try placing a space between the D and the comma.