Forum Discussion
Searching for similarities
A tree Map would visualize that nicely.
jteeple I am using a Tree Map! I was hoping that when I selected multiple strengths the list of names would go down so I would only see who had those say 3, but instead the list is anyone who has any one of the 3.
I'm not quite at Greg_Deckler 's level yet - and unfortunately I can't open the PBIX he sent due to version compatibility.
If you have suggestions on how to change the tree map so I could select multiple values and only see people with both - that would be great.
Have you created measures before? When I first started, it was all very Greek to me. What you should do is
1. Create 'New Table'
2. Get list of Distinct Names by typping Names = DISTINCT('Name of your table here'[Name])
That will create a table called names with a column called Name and fill it with the disctinct values from your original set of data.
3. Create 'New Measure'
4. Copy Greg's measure. You can use his names which may help the following explanation
% Alike = name of Measure or calculated value)
Variable PersonTraits = distinct list of traits from original dataset
Variable CompareTo = Gets the max count of names list in original table aka if my name was listed 20 times but yours was listed 5 it would return 20
Variable CompareTraits gets the distinct count where the person is being compared against the Max count of names listed and counting the traits to return a value
Variable Table is filtering the result of the PersonTrait variable against the results of CompareTraits
Variable Result is dividing the results of Table by the number of possible traits (5)
If this was helpful, vote for Greg. If not let me know and I can try again or maybe Greg can clarify if I messed up
