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 amitchandak,

Thanks for the response. 

I'm finding that both your suggested DAX and the solution from the YouTube link you provided are both not seeming to work for me.

BRR VS PRE-RFS AVERAGE TOTAL = 
SUMX(
    SUMMARIZE('NETWORK EXPANSIONS PROJECTS','NETWORK EXPANSIONS PROJECTS'[RFS.IND], "_new", [BRR VS PRE-RFS AVERAGE])
    , [_new])


Result (no total):


YouTube solution:

BRR VS PRE-RFS AVERAGE TOTAL = 
IF(
    HASONEVALUE('CALENDAR'[DATE])
    ,[BRR VS PRE-RFS AVERAGE]
    ,SUMX(VALUES('CALENDAR'[DATE]), [BRR VS PRE-RFS AVERAGE])
)


Result (wrong values):















My sample file is attached if it helps at all:
https://www.dropbox.com/s/h3kbeqwxeet2qcx/Power%20BI%20Issue.pbix?dl=0


Thanks for the assistance,
Jake

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