Calculated table of distinct columns

[olimilo]

Is it possible to get a table of distinct values for only the first 3 columns for the following table? I can do this using Power Query but would like to do the solution using DAX to avoid creating a new query to load:

NAME		TEST_NUMBER		TEST_RESULT		RESULT_NUMBER
1000347038		4777880		FAIL		65212748
1000347038		4777880		FAIL		65212747
1000347038		4777880		FAIL		65481797
1000347038		4777881		FAIL		65212749
1000347038		4777881		FAIL		65212750
1000347038		4777967		FAIL		65212751
1000347038		4777968		PASS		65212754
1000347038		4777968		PASS		65212760
1000347038		4777968		PASS		65212756
1000347038		4777968		PASS		65212753
1000347038		4777968		PASS		65212759
1000347038		4777968		PASS		65212757
1000347038		4777968		PASS		65212758

Essentially, after removing the RESULT_NUMBER the output would be:

NAME		TEST_NUMBER		TEST_RESULT
1000347038		4777880		FAIL
1000347038		4777881		FAIL
1000347038		4777967		FAIL
1000347038		4777968		PASS

[olimilo · Accepted solution]

Was able to accomplish this by using SUMMARIZECOLUMNS:

Table = SUMMARIZECOLUMS([NAME], [TEST_NUMBER], [TEST_RESULT])