Dax

[Dhrutivyasa-070]

Hello BI Community,

I have two table.
1. Scheme Table 
2. Master of DIstributor
Party name is name of Distributor who is eligibe for Scheme.  and Distributor contains all name of Distributor in Gujrat State.
relationship : State to State 

I want one column whe Party name is Equal to DIstributor then 1 otherwise 0

State	Party name	Distributor
Gujarat	xyz	abc
Gujarat	xyz	dfe
Gujarat	xyz	xyz
Gujarat	xyz	rtg

[eliasayyy]

as a measure:

IF(
   MAX('Table'[Party Name]) = MAX('Table2[Distributor]) ,
   1 , 
   0
)