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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
