Use Function to filter a dimension

[dcdjei]

I'm Trying to filter a measure using a formula that includes the GetFieldSelections() to filter the informasion ussing data that is selected in a different table that is not connected in the data model.

The expression that is not working is

if(Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'}, GetFieldSelections(MonthName) = {SignedMonth} >}ACVEur)=0,0,Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'} >}ACVEur))

If removed the expression without ", GetFieldSelections(MonthName) = {SignedMonth}" it is working but of course it is not filtering as expected.

Many thanks

[vchuprina · Accepted solution]

Hi, 

Try this:

if(Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'},
SignedMonth = {"$(= GetFieldSelections(MonthName))"}
>}ACVEur)=0,0,Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'} >}ACVEur))

Regards,

Vitalii