Calculate SUM of dax measures

avtandylru — Tue, 23 Apr 2019 10:42:21 GMT

Hu guys. I need to calculate sum of previous calculated measure.

Client  DaysInPeriod(measure)
 1        10
 2        25
 3        30
Total     30

Need

Client   DaysInPerdiod    Total
 1           10             65
 2           25             65
 3           30             65
Total        30             65

I' ve tried something like

Measure 2 = var DaysInPeriod = CALCULATE(DATEDIFF(CALCULATE(MIN(OvPortfolio[daydate_fuib]);ALLSELECTED('Calendar'[daydate_fuib]));CALCULATE(MAX(OvPortfolio[daydate_fuib]);ALLSELECTED('Calendar'[daydate_fuib]));DAY);ALLEXCEPT(OvPortfolio;OvPortfolio[clientid]))

return CALCULATE([DaysInPeriod];ALL(OvPortfolio))

But i get

Client   DaysInPerdiod    Total
 1           10             30
 2           25             30
 3           30             30
Total        30             30

Re: Calculate SUM of dax measures

avtandylru — Tue, 23 Apr 2019 12:58:00 GMT

CALCULATE(SUMX(DISTINCT(OvPortfolio[clientid]);CALCULATE(DATEDIFF(CALCULATE(MIN(OvPortfolio[daydate_fuib]);ALLSELECTED('Calendar'[daydate_fuib]));CALCULATE(MAX(OvPortfolio[daydate_fuib]);ALLSELECTED('Calendar'[daydate_fuib]));DAY);ALLEXCEPT(OvPortfolio;OvPortfolio[clientid])));ALLSELECTED(OvPortfolio))

topic Calculate SUM of dax measures in DAX Commands and Tips

Calculate SUM of dax measures

Re: Calculate SUM of dax measures