count values from multiple columns

Hi JMMSSAU , Before counting, I'd suggest first unpivoting the 6 item columns into a single column ,this makes the count much simpler and cleaner to work with.

In Power Query:
1. Select all 6 item columns (Item 1 through Item 6)
2. Right-click → Unpivot Columns
3. This gives you a single Value column with all items stacked
4. Remove the Attribute column (which just says Item 1, Item 2 etc.)
5. Filter out any blank/null rows
6. Then group by the Value column and count rows

Once everything is in one column, a simple **Group By** gives you exactly the Items + Count table you're after — no complex cross-column logic needed.

Hope that helps!

Thanks!

Natarajan Manivasagan

If you found this helpful, please consider giving it a Kudos and marking it as the accepted solution — it goes a long way in helping others facing the same issue.

🏆 Best Solution for Enterprise BI — 2026 Microsoft Fabric Semantic Link Developer Experience Challenge
👉 Microsoft announcement · View the winning notebook

For more Power BI tips and discussions, let's connect on LinkedIn.

Cheers!