Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Blank Measure Total

I have a model that includes three measures - all working correctly except no total appears. I want to show a cumulative total in a card visual. Measure 1 (simple revenue sum with some parameters)...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

I suggest you to add a year and a month column in calendar table instead of using time intelligence. Then try this code.

BRR VS PRE-RFS AVERAGE TOTAL = 
SUMX(
    SUMMARIZE('CALENDAR','CALENDAR'[Year],'CALENDAR'[Month], "_new", [BRR VS PRE-RFS AVERAGE])
    , [_new])

Result:

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous, thanks very much for the suggestion - this answer is very close.

 

It is summing the values like I need but it is providing YTD cumulative totals rather than a life-to-date cumulative total - do you know how to achieve this?

 

 

Kind regards,

Jake