topic Re: Sum a calculation made on each line in DAX Commands and Tips

Sum a calculation made on each line

Anonymous — Sun, 24 May 2020 08:23:06 GMT

HEllo everyone,

I have a simple problem I can't seem to figure out on my own.

I have a table of clients, with a column indicating the date of first purchase for a specific product line.

I have a date filter.

I want when i change the date filter, to evaluate on each line if the first purchase was in the time range selected in the filter, if so count 1 for that line, and sum the 1 to get a count of clients who made a purchase in that time range.

In SQL I would do that:

SUM(CASE WHEN date_first_purchase BETWEEN first_date AND last_date THEN 1 ELSE 0 END)

Is there a way to do that in DAX?

Thanks a lot!

Re: Sum a calculation made on each line

nandukrishnavs — Sun, 24 May 2020 09:01:39 GMT

Anonymous

Can you share the sample data so that we can validate the logic?

Re: Sum a calculation made on each line

Anonymous — Sun, 24 May 2020 12:18:40 GMT

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Sum a calculation made on each line

Anonymous — Sat, 30 May 2020 07:32:21 GMT

I reread the documentation and achieved the desired results with a SUMX and CALCULATE with a little tweaking. Thanks anyway!