Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Count only single cells in Power Query

I have the following situation, in column B I have identified delivery numbers which are repeated n number of times according to the number of plants in column E. How can I count and show me If colu...
  • vicky_'s avatar
    vicky_
    2 years ago

    For Power Query, you'll need to grab just column B and Column E, select both columns by holding CTRL or Shift while clicking, then Remove Rows > Remove Duplicates

    then go to Transform > Count Rows. You can close and apply after that.

    You can also do it in DAX. Load in your data as normal (after applying any transformations that you already had), then use the following measure: 

    Unique Combinations = COUNTROWS(DISTINCT(SELECTCOLUMNS('Table', 'Table'[Column B], 'Table'[Column E])))

     

vicky_'s avatar
vicky_
Super User
2 years ago

For Power Query, you'll need to grab just column B and Column E, select both columns by holding CTRL or Shift while clicking, then Remove Rows > Remove Duplicates

then go to Transform > Count Rows. You can close and apply after that.

You can also do it in DAX. Load in your data as normal (after applying any transformations that you already had), then use the following measure: 

Unique Combinations = COUNTROWS(DISTINCT(SELECTCOLUMNS('Table', 'Table'[Column B], 'Table'[Column E])))