Forum Discussion
JoseQ
6 years agoFrequent Visitor
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 ...
jstorm
Resolver III
6 years agoThe syntax should be...
TOTALQTD(
SUM( SalesbyProd[Sales income] ),
'Time'[Date]
)
Can you post a screenshot of your model? Can you post you MTD and YTD measure syntax?
JoseQ
6 years agoFrequent Visitor
hi, thanks for the fast response.
I tried changing the syntaxis but gave the same results.
By model you mean relationships if so.. this is the model..