Hard Coded Values

[SJ_16]

Hi,

I have a variable called 'Company' of which is used as a Filter and this has two options - RI and NT each has there own values. So when I select the individual options, the charts change as expected. 

However what I need is one variable 'FC_New' to show a hard coded value of 70 when the filter is not selected. 

This is my existing measure logic:

sum({$<CV_Year={$(=YEAR(TODAY()))},[Dash]={'Rate_On'}>}[Budget Value])

 I'm assuming I would need to create a new variable like below and call it say 'vRate' 

if(getselectedcount([Company])=0,70,1))

and then my measure logic will look something like

sum({$<CV_Year={$(=YEAR(TODAY()))},[Dash]={'Rate_On'}>}[Budget Value]) / $vRate  ?

[sunny_talwar · Accepted solution]

May be you need this

If(GetSelectedCount(Company) = 0, 70, Sum({$<CV_Year = {$(=Year(Today()))}, [Dash] = {'Rate_On'}>} [Budget Value]))