Forum Discussion
YTD Calculation Blank Values
Hi TSales,
I re-created your data model and measures as best as I could from your description and don't have the issue you're describing. Can you please share your pbix? (If you don't know how, please see the pinned thread in the forum.)
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Memorable MemberHi TSales,
I re-created your data model and measures as best as I could from your description and don't have the issue you're describing. Can you please share your pbix? (If you don't know how, please see the pinned thread in the forum.)
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
It gives me the correct YTD number of 6 when selecting July, but the CC row is not showing up.
- Wilson_
TSales,
Changing the cross filter direction to single instead of both fixes your issue.
As you can see from my screenshots, the relationship between the two tables is not bi-directional. As a general rule, you should only use single direction relationships; your lookup/dimension tables should filter your fact tables only.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)Thank you very much for the help!