Forum Discussion

capko's avatar
capko
Icon for Helper II rankHelper II
3 years ago

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...
Need Help
galaamri's avatar
galaamri
Icon for Helper I rankHelper I
3 years ago

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)

  • capko's avatar
    capko
    Icon for Helper II rankHelper II
    3 years ago

    I need to do it using DAX. I started like this:

     

    Test=
VAR A = SUMMARIZE(Table;Table[A])
RETURN A

     

     

    But with this I only can return a table with distinct elements

    • galaamri's avatar
      galaamri
      Icon for Helper I rankHelper I
      3 years ago
      Measure =
       var _A = DISTINCT('Table'[A])
               return
               _A
          
      • capko's avatar
        capko
        Icon for Helper II rankHelper II
        3 years ago

        It wont work as requested because the output wont be the same as the one shown in m first post