How to make a number static ?

[Anonymous]

Hi All,

Would like to ask how to make the number 2678400 static ?

The formula that was given to me is this :

(86400*(sum({$<[DATETIME.autoCalendar.Date]={">=$(=YearStart(Max([DATETIME.autoCalendar.Date]), 0))<=$(=YearEnd(Max([DATETIME.autoCalendar.Date]), 0))"}>*<TECHNOLOGY = {'2G'}>} CELLNUMBER)))

Regards,

Mahirah

[petter]

You have to explain what you mean by static ...

If you want to have it used multiple places you can put the calculation into a variable or a master measure.

[avinashelite]

Static in the sense you don't want this number to change ...even when you make selection ?? in that case try like this

(86400*(sum({1<[DATETIME.autoCalendar.Date]={">=$(=YearStart(Max([DATETIME.autoCalendar.Date]), 0))<=$(=YearEnd(Max([DATETIME.autoCalendar.Date]), 0))"}>*<TECHNOLOGY = {'2G'}>} CELLNUMBER)))

[Anonymous]

By what I meant static is  :

if select any of the option on the left whether it is region , technology, category, etc , the number will stay static.

and I just want to use it to divide by a certain category.

[Anonymous]

Hi Avinash,

Seems like it doesn't work, everytime i clicked on any of the selection.

[immkhan2]

Use the required formula in Variable and use afterwards where-ever required.

[avinashelite]

Try like this

(86400*(sum({1<[DATETIME.autoCalendar.Date]={">=$(=YearStart(Max({1}[DATETIME.autoCalendar.Date]), 0))<=$(=YearEnd(Max({1}[DATETIME.autoCalendar.Date]), 0))"}>*<TECHNOLOGY = {'2G'}>} CELLNUMBER)))