Too Many Arguments Q.

[Anonymous]

I am trying to write a measure that will allow me to filter on statuscode and Datesbetween. With the filter, plus the two conditions, I have too many arguments for the FILTER function. What syntax can I use to get the desired result?

Won-Existing = SUMX ( FILTER ( _enquiries, _enquiries[_GUID] = _2018_Budget[_GUID] &&

_enquiries[statuscode] = 866120005 &&

DATESBETWEEN(_enquiries[Date Contract Awarded],DATE(2018,8,1),DATE(2018,8,31) )

, _enquiries[Amount (Enq)] ))

[v-jiascu-msft]

Hi @Anonymous,

Maybe this one?

Won-Existing =
CALCULATE (
    SUMX (
        FILTER (
            _enquiries,
            _enquiries[_GUID] = _2018_Budget[_GUID]
                && _enquiries[statuscode] = 866120005
        ),
        _enquiries[Amount (Enq)]
    ),
    DATESBETWEEN (
        _enquiries[Date Contract Awarded],
        DATE ( 2018, 8, 1 ),
        DATE ( 2018, 8, 31 )
    )
)

Or this one?

Won-Existing =
CALCULATE (
    SUMX ( _enquiries, _enquiries[Amount (Enq)] ),
    DATESBETWEEN (
        _enquiries[Date Contract Awarded],
        DATE ( 2018, 8, 1 ),
        DATE ( 2018, 8, 31 )
    ),
    FILTER (
        _enquiries,
        _enquiries[_GUID] = _2018_Budget[_GUID]
            && _enquiries[statuscode] = 866120005
    )
)

Best Regards,
Dale

[Anonymous]

Thanks for trying, Dale.

The first one gives me this error:

A single value for column '_GUID' in table '_2018_Budget' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

The second one gives me this error:

A date column containing duplicate dates was specified in the call to function 'DATESBETWEEN'. This is not supported.

Any other thoughts. I appreciate all your help.

[v-jiascu-msft]

Hi @Anonymous,

Regarding the first one, what's the relationship between '_enquiries' and '_2018_Budget'? Maybe you can do it like this.

Won-Existing =
CALCULATE (
    SUMX (
        FILTER (
            _enquiries,
            _enquiries[_GUID] = min(_2018_Budget[_GUID])
                && _enquiries[statuscode] = 866120005
        ),
        _enquiries[Amount (Enq)]
    ),
    DATESBETWEEN (
        _enquiries[Date Contract Awarded],
        DATE ( 2018, 8, 1 ),
        DATE ( 2018, 8, 31 )
    )
)

Regarding the second one, please create a new date table and establish a relationship with '_enquiries'. Actually, the first one has the same issue. 

Can you share a dummy sample?

Best Regards,
Dale