Evaluating if two fields (from separate tables) equal in DAX

[Anonymous]

I am trying to count a field if two fields are equal. I think the problem is the two fields are in separate tables. However the appropriate joins are in place that create a relationship between these fields/tables.

The expression I am trying to write (but it doesn't work):

Optimization = CALCULATE(countx(ITEM,ITEM[RecommendedStrategy]),FILTER(ITEM,ITEM[RecommendedStrategy]=STRATEGY[Actual Strategy]))

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Create the following column in your ITEM table.

Column = LOOKUPVALUE(STRATEGY[Actual Strategy],STRATEGY[Actual Strategy],'ITEM'[RecommendedStrategy])

Then create the following measure in the ITEM table.

Optimization = CALCULATE(COUNTROWS('ITEM'),FILTER('ITEM','ITEM'[RecommendedStrategy]='ITEM'[Column]))

Regards,
Lydia

[Anonymous]

Hi

Please try RELATED in your formula.

RELATED ( STRATEGY[Actual Strategy]) )

Thanks
Raj

[Anonymous]

Can't get that to work.

[PattemManohar]

@Anonymous Could you please post sample data for resolving your issue.

[Anonymous]

Where is the icon to attach an excel file?