Possibly a measure expression will help here but you may need to use more measures to achieve what you're chasing.