Forum Discussion
adding row values only
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.
3 Replies
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 !!
hi sir got an error
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.
