Use Function to filter a dimension

dcdjei — Tue, 17 May 2022 10:59:51 GMT

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

Re: Use Function to filter a dimension

vchuprina — Tue, 17 May 2022 13:50:08 GMT

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

topic Re: Use Function to filter a dimension in App Development

Use Function to filter a dimension

Re: Use Function to filter a dimension