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?
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])))
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])))
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
