Forum Discussion
Distinct elements related to another column
Hello, I have the following table: | A | B |
|----|----|
| A1 | M1 |
| A1 | M2 |
| A2 | M5 |
| A2 | M3 |
| A2 | M1 |
| A2 | M3 |
| A3 | M7 |
| A3 | M1 | I need to find the distinct...
Hi capko
In the power query view, choose remove duplicate under rows, and this should do it. or use distinct ( as a measure or calculated column)
I need to do it using DAX. I started like this:
Test= VAR A = SUMMARIZE(Table;Table[A]) RETURN ABut with this I only can return a table with distinct elements
