Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Weird Grand Total issue

Weird situation.  I have 2 measures. 

 

1. Total Points := Calculate(Sum(Points),All(Test[Jerseys])

 

2.  Points by Jersey := Sum(Points)

 

When i filter on jersey 0 

 

1.=143,715

2.=53636

 

When i filter on jersey 14

1.=90,443

2.=81,286

 

My thoughts are by adding the "All(Test[jersey]" filter that is that all values, regardless of jersey, should be added in 1.  what am i doing wrong?

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    When you use Direct Query, the date format is same as in SQL server database, you can add a custom column in Query Editor to convert your date column as posted in this case. Or you can try  to Use Locale for Date Conversion, please review "Date Conversion Using Locale" part in this blog.

    Best Regards,
    Angelia

13 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    HI Anonymous

     

    Is your filter actually using the [Jerseys] column from the 'Test' table?  or are you using a related column from a different table for your filter?