circular dependancy error on the columns which are not related

[unnipbi123]

Hi,

I have a calculated table in my desktop and i am trying to create two calculated columns in that.

column 1: to find the total unpaid seats for the current month

currentmonth NFR = CALCULATE(SUM(NFR_Aging[NFR seats]),YEAR(NFR_Aging[Date])=YEAR(TODAY()) && MONTH(NFR_Aging[Date])=MONTH(TODAY()))

column 2: to find the total paid seats for the current month

currentmonth SEATS = CALCULATE(SUM(NFR_Aging[paid seats]),YEAR(NFR_Aging[Date])=YEAR(TODAY()) && MONTH(NFR_Aging[Date])=MONTH(TODAY()))

when i try to create  a second calculated column, i am getting the error as below

for both calculations, i am calculating sum of two different columns. not sure why there is a dependancy error. Please help

Below is the table structure

Date

dist-id

res-id

channel

dist-name

res-name

region

NFR seats

paid seats

[amitchandak · Accepted solution]

@unnipbi123 , Both seem fine, But you should create them as measures

currentmonth NFR = CALCULATE(SUM(NFR_Aging[NFR seats]),YEAR(NFR_Aging[Date])=YEAR(TODAY()) && MONTH(NFR_Aging[Date])=MONTH(TODAY()))

currentmonth SEATS = CALCULATE(SUM(NFR_Aging[paid seats]),YEAR(NFR_Aging[Date])=YEAR(TODAY()) && MONTH(NFR_Aging[Date])=MONTH(TODAY()))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[unnipbi123]

Thanks. it worked