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
Icon for Resolver III rankResolver 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