Forum Discussion

AA364's avatar
AA364
Regular Visitor
3 years ago

Searching for similarities

I have a large data set - over 100 people, each with 5 strengths associated with them, there are 34 total strengths. I'm wondering what tools I could use to tell me which people have the most in comm...
Need Help
AA364's avatar
AA364
Regular Visitor
3 years ago

Greg_Deckler Here is a screen shot of the source data. I had to unpivot in PowerBi to get it to do what I want - but I think you get the general idea.

 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

AA364 See if the attached PBIX below signature helps. Did this with a disconnected table and this measure:

% Alike = 
    VAR __PersonTraits = DISTINCT('Table'[Value])
    VAR __CompareTo = MAX('Names'[Name])
    VAR __CompareTraits = DISTINCT(SELECTCOLUMNS(FILTER(ALL('Table'), [Name] = __CompareTo),"__Traints",[Value]))
    VAR __Table = FILTER(__PersonTraits, [Value] IN __CompareTraits)
    VAR __Result = DIVIDE( COUNTROWS(__Table), 5 )
RETURN
    __Result