Avoid creating measure groups that have the same dimensionality and granularity
This rule analyzes whether there are multiple measure groups within a cube that contains measures that have the same dimensionality and granularity. This rule does not apply to distinct count measures.
For best performance, you typically consolidate multiple measure groups that have the same dimensionality and granularity into a single measure group. However, do not consolidate measure groups that contain distinct count measures into one measure group. Instead, put each distinct count measure in its own measure group for best performance. Each distinct count measure group should have the same dimensionality and granularity as the non-distinct count measures from the same fact table.