Forum Discussion
Column (sub) total not correct from measure
Hello. I have created a measure which shows the monhtly value between two dates, a start and an end date. Current Rev per monht = CALCULATE(
SUM('Rev contract'[Rev per Month]),
...
Ok I managed to get annual totals by combining the SUMX funciton
Rev per Month =
SUMX(VALUES(Calendar[Month]),[Current Rev per month]
)This works only on an annual level. Not for multiple years. I would expect the total for multiple years