The syntax for 'USERELATIONSHIP' is incorrect

[Anonymous]

I have created a new measure for Agreement that is giving  error message

This is the measure:

Agreement = LASTNONBLANKVALUE(Waterfall_Mnthly[Number], )

USERELATIONSHIP('SalesRevenue_Mnthly'[Waterfall_Link], Waterfall_Mnthly[Waterfall_Link]), NOT(ISBLANK('SalesRevenue_Mnthly'[Waterfall_Link])))

error message is 

The syntax for 'USERRELATIONSHIP' is incorrect

[HashamNiaz]

Hi @Anonymous !

You should use following approach, create a measure with all the filters you need to apply, then create another measure in which you call first measure plus forcing the inactive relationship to play with UserRelationship()

See below for example;

Agreement = CALCULATE(LASTNONBLANKVALUE(Waterfall_Mnthly[Number]), NOT(ISBLANK('SalesRevenue_Mnthly'[Waterfall_Link])))

Agreement FR = CALCULATE ([Agreement], USERELATIONSHIP ('SalesRevenue_Mnthly'[Waterfall_Link], Waterfall_Mnthly[Waterfall_Link]))

You need to make sure you have inactive relationship in place between 2 tables.

Regards,

Hasham