Forum Discussion

JoseQ's avatar
JoseQ
Frequent Visitor
6 years ago

Measure TOTALQTD not working

I have two tables: 1. Sales by product ID 2. Time  There's a relationship between these two tables where cardinality is many to one (*:1) and cros filter direction is both. The field key is the ...
Need Help
jstorm's avatar
jstorm
Resolver III
6 years ago

Is your sales data only being recorded once per quarter?  For example,

3/1 $1000

6/1 $2000

9/1 $1500

12/1 $1000

 

Try putting your data into a table visualization without any measures to see if there are any inconsitencies or some underlying logic you are not considering.

  • JoseQ's avatar
    JoseQ
    Frequent Visitor
    6 years ago

    My sales data is being recorder daily.

     

    However my time table is comprised of difrente time scales: daily, weekly, monthly, bimestraly, quarterly, triannually and semestraly...

     

    This for example:

    [CONFIDENTIAL INFO.]

     

    • jstorm's avatar
      jstorm
      Resolver III
      6 years ago

      Set up a table visualization with Time[Month], Time[Quarter], Time[Year], and your YTD, MTD, QTD measures.  Check to see if there are problems there and post a screenshot.  Also, check your columns in Time and Sales to be sure they are the right data type.

      • JoseQ's avatar
        JoseQ
        Frequent Visitor
        6 years ago

        Pleaes take a look.

         

        I see many inconsistencies within the data table:

        • May and June shouldn't have any values on 2020 QTD Sales Income measure (last sales record is on 26th april).
        • May thru December should have any values on 2020 YTD Sales Income measure (lasta sales record is on 26th april).
        • QTD Sales income measure should only account the sales from 1st Jan- 31st March and it's throwing the same value as YTD Sales Income measure (its adding values from 26 days of April).

        [CONFIDENTIAL INFO.]

        Please help.

         

        Thnks,

        JQ