Forum Discussion

PSan1979's avatar
PSan1979
Icon for Helper II rankHelper II
6 years ago
Solved

Issue with Joins

Hi Experts   I have 2 tables Att( personid,matdistance,catergory) & clus(personid, Grpid, type(buyer/seller)), there should be 1:M from att to clus, due to many duplicates in att, created a table(l...
Need Help
  • PSan1979's avatar
    PSan1979
    6 years ago

    @v-lid-msft Thank you for the effort

    catering column depending on the condition.

    If matdistnce > 6 then Far else Near

    grpid -distinctcount(grpid)

    I need something like this.

    Capture.JPG

    but I'm currently getting 18 for both and close. it's a bad thing with the data model. I've used the same joints as I u used

PSan1979's avatar
PSan1979
Icon for Helper II rankHelper II
6 years ago

v-lid-msft  Thanks for the effort

 

caterory column based on condition.

 

If matdistnce> 6 then Far else Near

 

grpid =distinctcount(grpid)

 

i need something like this

 

 

 

 

but currently i am getting 18 for both far and near. is something wrong with data model. i have used same joins as u used

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi PSan1979 ,

 

We can try to use following measure to get desire result:

 

Grpid =
CALCULATE (
    DISTINCTCOUNT ( 'clus'[Grpid] ),
    FILTER ( 'Clus', 'Clus'[personid] IN DISTINCT ( 'Att'[personid] ) )
)


Best regards,