Create measure by using two measure with condition

[Anonymous]

Hi,

I have two measure NettingExp and NonNettingExp. I want to show these value in single column. Like'ResultData'[Status]="Netting" then show NettingExp measure else show NonNettingExp measure. 

Visual Example:-

PartyName     Expense(Either NettingExp or NonNettingExp)

I tried to add calculated column but not able to create as showing circuler dependency error. Any way to create measure like 

ExpenceMeasure = IF(ResultData'[Status]="Netting", NettingExp, NonNettingExp) ???

Please advise on this !!  

[JosefPrakljacic]

Hello Kumar,

without sample data and sketching your model, we can only guess.

It is no shame to publish sample data and would help those who want to help you.

So may I ask you for sample data?

Here is a good article about how to avoid circular dependencies -> https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

BR,

Josef