Forum Discussion

hnguyen76's avatar
hnguyen76
Icon for Resolver II rankResolver II
6 years ago
Solved

Sum Measure Grand Total in Visual is Blank

Good morning, All.   I have a few simple measures that seems to give me the correct numbers but my grand total is showing as blank. I can't for the life of me understand why my total isn't showing....
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi hnguyen76 

    whats result do you expect in Total of Bucket1?

    If sum of each values of this column try

    Bucket1 = sumx('Table';IF([Current] = [Previous]; [Current]; BLANK()))

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

hnguyen76's avatar
hnguyen76
Icon for Resolver II rankResolver II
6 years ago

Hi az38 ,
Thanks for the response. -29,816.42 was the expected total and the SUMX did work and in terms of the sample data but when I applied it to my actual real numbers (which uses the same table) it gives me a different result:

The formula is as followed:

#Same Diff = SUMX(Dim_L1_Historical, IF([Current] = [Previous], [Current], BLANK()))

 

parry2k ,
Thanks for your response and I normally would use a date table to create time intelligence calculations but I'm working with a data set that does not have an actual date. For this current iteration, it would be more work to convert the string into a date. 

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

hnguyen76 

and so whatr are you expect to see in 

#Same Diff

column? there are only two zeros in your example

do not hesitate to give a kudo to useful posts and mark solutions as solution

 

  • hnguyen76's avatar
    hnguyen76
    Icon for Resolver II rankResolver II
    6 years ago

    Hi az38,
    I'm expecting to see -50,971.82 instead of the zeros

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      hnguyen76 

      try

      Bucket1 = calculate(sumx('Table';IF([Current] = [Previous]; [Current]; BLANK())))

      do not hesitate to give a kudo to useful posts and mark solutions as solution

      • hnguyen76's avatar
        hnguyen76
        Icon for Resolver II rankResolver II
        6 years ago

        az38 ,

        Same result. I'm only getting the zeros which are wrong in any case.