Calculating Total by Measure

---

dkushner wrote:

Thanks, it’s working. now one more question.

If I need to implement 1  more filter by measure (I need to select exact Counters from the column). What should I do?

Or how can I use a filter directly in the formula. For example I would like to calculate Total Delta by Aplus only for 2 counters with the numbers 18 and 50.

---

Hi dkushner,

Please check that if the following DAX returns your expected result.

sumdelta = SUMX(VALUES(PowerCounters[CounterNumber]), [Delta by Aplus])
Total Delta = CALCULATE([sumdelta],FILTER(PowerCounters,PowerCounters[CounterNumber]= "18"||PowerCounters[CounterNumber]= "50"))

However, if you want to calculate SUM of “Delta by Aplus” in a specific date range, create a date column using following DAX.

Date = DATE(YEAR(PowerCounters[DateT]),MONTH(PowerCounters[DateT]),DAY(PowerCounters[DateT]))

Then create the following measures, specify date range in the filter of Total Delta measure.

sumdelta = SUMX(VALUES(PowerCounters[CounterNumber]), [Delta by Aplus])
Total Delta = CALCULATE([sumdelta],FILTER(PowerCounters,PowerCounters[Date]<=DATE(2017,3,29) && PowerCounters[Date]>=DATE(2017,3,28)))

Thanks,
Lydia Zhang