Count only single cells in Power Query

[Syndicate_Admin]

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 column B and column E is unique let it be = 1 if this combination is repeated it will be empty.

Can this be done in any way in Query?

[vicky_ · Accepted solution]

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])))