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

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

Hi PSan1979 ,

 

What are the columns you applied into the fields of visual? Have you tried to use the personid in the distinct table as the field? Or you can try to change the single relationship to both.

 

 


By the way, PBIX file as attached.


Best regards,

 

PSan1979's avatar
PSan1979
Icon for Helper II rankHelper II
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