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
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Because you have used the row context. Based on the visual group by you need to use values/summarize to get grand total

Sumx(

Summarize('NETWORK EXPANSIONS PROJECTS', 'NETWORK EXPANSIONS PROJECTS'[RFS IND] ,"_new",[BRR VS PRE-RFS AVERAGE]) ,[_new] )

https://www.youtube.com/watch?v=ufHOOLdi_jk

  • 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