Forum Discussion
Solved
struggling with matrix aggregation results
for some reason my return quantity is showing incorrectly. I have the return set as a measure, but when i put it in the matrix it shows incorrectly. I am pretty new and cannot figure this out. ...
no problem, your relationship between adventure works and the calendar is deactivated, its got a dotted line. you need to double click on it and make it active. that why the relattionship isn't working right now
abpgupta
Continued Contributor
Continued ContributorWhile working with measures, you need to understand what's correct value to display for each context:
1. Row Context ( what other fields involved)
2. Filter Context ( outside filters)
Max etc function can be set inside measure calculation so you don't need option to change on UI.
My suggestion is breakdown your problem logic using Table visual to arrive at correct result for given row context and then use performance analyzer to generate DAX for creating measure.
no idea how to do that.