topic Re: adding row values only in DAX Commands and Tips

adding row values only

Easley06 — Tue, 21 Feb 2023 04:10:51 GMT

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 — Tue, 21 Feb 2023 04:27:19 GMT

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 — Tue, 21 Feb 2023 05:05:37 GMT

hi sir got an error

BrianConnelly — Tue, 21 Feb 2023 05:14:49 GMT

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.