SUM, SUMX or CALCULATE().Choices, choices!
When I was working recently with a client, helping her remotely - I asked her to calculate the sum for sales amount in the table. She responded whether she should use SUM, SUMX or CALCULATE? Simple question, but not a simple answer. Or I can give you the classic lawyer response - "It depends!" Let's review.
Read more...