Measure to show field based on another field

[fzins]

I have a tabular Visual with 2 fields.

Field A from table A shows the 'Status' and field B from table B shows the 'Code'.

I want to show the code only when Status='Denied'. Otherwise it should be blank.

I successfully implemented this with conditional formatting, but when the report is downloaded it'll show the code by all statuses.

How can I create this using a measure?

[fzins]

Thank you for that. I changed the relationship to one to many and created the measure. However, my table now shows only 'Denied' records. 

The measure somehow filters my data to 'Denied'.

Any advice?

[kpost]

Would it be possible to re-create the scenario with sample data in a sample .pbix file then upload it somewhere and provide a link?

Failing that, the only suggestion I have is to make sure that in your table visual, the 'ClaimID' column has "Show Items with no data" selected, like this:

 

[fzins]

Thank you for taking the time to respond.

My two tables are joined with a one to one relationship of tblClaims.ClaimID to qryERA_PBI.ClaimID

TblClaims.ClaimStatus has values such as 'denied', ;paid' , 'claim in process', 'claim submitted' and qryERA has all denied claims (ClaimID) where Status is 'Denied' or  'Paid'

Hope this helps

[kpost]

okay so I recreated your problem with these two tables:

TblDocrite.ClaimStatus

qryERA 

But I changed the relationship to many to one, with single-direction cross filtering, from TblDocrite to qryERA.

Then I made this table

Using TblDocrite.ClaimStatus[ClaimID], TblDocrite.ClaimStatus[Status], and the following measure:

Code_Measure =

var claimstatus = SELECTEDVALUE('TblDocrite ClaimStatus'[Status])

var code = max(qryERA[Code])

return

IF (claimstatus = "denied", code, BLANK())

See attached .pbix file with a working solution.

///Mediocre Power BI Advice, but it's free///

[kpost]

Can you upload sample data for the two tables, tell us about any active relationship(s) between the two tables in your data model, and/or a .pbix file containing the problem (ideal)?