How to organize measures names

[matemusic]

Hi,

is there any simple way to use same name of measurement for different formula?

For example, I have two report pages with different calculation. On both pages I have table with same column names, but on each table are different formulas. 

One table has column name Sales, which is simple calculating total sales.

On the other table I have cumulative of total sales, but i want to name it just Sales.

I did a simple trick: Just add space after Sales (one is "Sales", other is "Sales "). But it is not best method, beacuse it is hard to distinguished them. 

I tried with commenting (/*Cumulative*/ Sales), but the comment is then showed on table too.

Thanks

Regards

Mate

[Seth_C_Bauer]

@matemusic If you are asking about measure naming conventions, I would recommend making a distinction between the two. You would have no way to tell in the model which measure was which using your current method. Others may have a different opinion, but I typically use the main name first with either an underscore or camel case to describe the measure.

Example:

Sales_Avg

Sales_CuTotal

Sales_Total

or 

SalesAvg

SalesCuTotal

SalesTotal

In this regard, all your measures related to sales are in the same location in the table for a specific measure you or an end user is looking for.

[matemusic]

Hey, thanks for your answer and sory for lack of clarity, i am not so good at expressing in english 🙂

Yes, I was talking about different measures with the same name. I don't realy want them to have the same name on list of measures, but I want the same name on report, beacuse some visualisations require minimal changes to get expected result.

Thanks  🙂

[Greg_Deckler]

A little confused. You can have the same column name in 2 different tables. Are you referring to "measures"? Because you cannot have 2 measures with the same name.