Need HELP with DAX comparison

[tracyhopaulson]

I have 2 tables (PO & Item) that have the 2 elements I am doing a comparison.  If the Line Revision and the PO Revision for each PO is the different, then I want to mark it "True" for further analysis.  I've tried Rev Comparision= IF(PO[PORevision]=Item[ItemRevision], "True", "False") but it's giving me error! for example, Line 7 where the revision is not the same, I would want to mark it false.   Can someone help please?

[v-chuncz-msft]

@tracyhopaulson ,

You may try the DAX below to add a calculated column.

Column =
IF ( RELATED ( PO[PORevision] ) = 'Item'[ItemRevision], "True", "False" )

[tracyhopaulson]

I entered your formula and got error that the ItemRevision column either doesn't exist or doesn't have a relationship to any table available in the current context. 

[MFelix · Accepted solution]

Hi @tracyhopaulson ,

Based on the file you sent me trough private message do the following:

• Create the following measure:

RevComparision = MAX(Items[Revision]) = MAX(PurchaseOrderLines[Revision])

• Add the PurchaseOrderLines[Line] to your filter pane and select is not blank, final result is below:

Regards,

MFelix

[tracyhopaulson]

@MFelix  yes, this works.  You're a super STAR.  Thanks for your help 🙂