Forum Discussion

Dhrutivyasa-070's avatar
Dhrutivyasa-070
Icon for Helper I rankHelper I
3 years ago

Dax

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

StateParty nameDistributor
Gujaratxyzabc
Gujaratxyzdfe
Gujaratxyzxyz
Gujaratxyzrtg

1 Reply

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    as a measure:

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