POWER BI - Not able to add a new Calculated column.

[Fizi]

Hi Dear ALL,

Look at the function below.  As you see there Userelationship function. Therefore I was not able to add a new calculated column.  I was able to add a new calculated column after removing Userelationship function. I don't know what the reason is.

ANNUAL_365_COST = CALCULATE(SUM('HRKT FULL'[AZN]),

FILTER('HRKT FULL', 'HRKT FULL'[ORTKOD]=RPRZ[ORTKOD]), DATESINPERIOD('HRKT FULL'[TARIX].[Date], TODAY(),-1, YEAR), 

USERELATIONSHIP(RPRZ[ORTKOD],'HRKT FULL'[ORTKOD]), 'HRKT FULL'[TURT]="CIXIS", RPRZ[VED] IN{"V","E","D"})

[Deku]

USERELATIONSHIP must be used in CALCULATE as a context modifier, which are doing. Please see this SQLBI post on using USERELATIONSHIP in calculated columns. 

[Fizi · Accepted solution]

Thanks for you reply.  I tested the same function several times to add a new column. However, I didn't get any errors with it. Instead, I just get a blank column called Column1. It would be better if I got an error about it. I wouldn't waste my time testing it multiple times. Thanks a lot.