can a previously defined calculated fields be used while creating a measure??

[Anonymous]

Hi All PBI Gurus 🙂,

Though i'm pretty new to POWER BI, i'm already in love with it and trying to learn in pretty fast.

facing a new challenge today, where i know the reason but not able to fix it. As per my knowledge fields used in measures has to be used with aggregation functions but....

Problem Statement: Trying to create a new measure named "Current_Status" where i am using a previously defined calculated field "Status". The field "[F1U?]" from the data is a boolean field holding answers in Yes/No.

Below mentioned is the DAX code,

Current_Status = IF(AND(query[F1U?]="No", (query[Status]>=5)),"Updated",

IF(AND(query[F1U?]="No", query[Status]<5),"Pending",

IF(query[Status]=7,"Updated","Pending")))

attached are the error screenshots for reference.

Thanks in Advance for you help!

[Anonymous · Accepted solution]

you should create a colum instead of a measure. Measures are used to summarise.