Make a Measure Item Distinct

1.   Right-click a calculated measure item in the grid or view explorer, and select Properties.

2.   In the Properties window, select Distinct Calculated as the type.

3.   Click OK in the prompt that informs you the change will cause the measure item to be moved to the end of the view.

4.  {Optional} If you want the measure item positioned at the beginning of the view, drag and drop it to that position in the Measure Items folder of view explorer.